Category : Windows 3.X Files
Archive : QWNSQL2A.ZIP
Filename : SQL.HLP
Output of file : SQL.HLP contained in archive : QWNSQL2A.ZIP
6<@MSVZ_er{£±Á @ Z n ½ À õ
*
1
C
G
S
X
^
l
p
u
& / 3 ; Ò Ø á Y Ò i
o
s
y
¦
¬
¯
³
¼
Æ
Ï
×
Ü
ã
æ
ô
",9EQcs©½ÃÌÖàæëðóöù^²Ó×,L¢8ÄÈØàäëðøü (19?KQ^gjnv}¬³¶¼ÇÊÒÜïöÿ .=AEKR^dirv|ØÞãèîòû
&*/5<BHQ[eiqz£«³¼ÆËÑØßåìóûCRW_oxÆ &.9DLU[eivz~¦¬³ºÅûoux}¡ª³»ÃÊÕßäìôùþ7X^Þâèíò÷ü (-19AOfo
#*29>dz §³ºÄÉÒÛT^iu ¤¨¯²µ»ÂÉÌÛêóÿ ! ' + / 5 < ? E L P T b m y © º Ç Ó Ü ö
0 4 8 ? E J V ] ` d k q y } ¤ ¸ Å Ò â ê ô ! % * . 3 6 : > A E K R W ] e h l u x | ¦ ¬ » Ã Æ Ë Ô × Û ß ã ì õ 4 a ß A L Ä ò !6!@!F!N!U!`!f!n!!!!!!!¨!±!·!À!È!Ì!Õ!Ü!ç!ï!ô!""
""""%","2";"D"J"P"]"d"k"t"{"""""§""¹"À"É"Ï"×"Ý"â"è"ë"ï"ô"ú" ##
## # #'#5#L#T#[#a#g#m#s#w#~####£#ª#±#º#Ä#Î#Ô#Ù#ß#å#î#÷# $$2$<$F$N$X$\$b$h$t$$$$$ $¦$¬$²$º$Ä$È$Ì$Ð$Ó$×$Û$à$å$ë$ï$ô$û$ÿ$T%Y%^%i%t%%%%©%®%³%½%Ã%É%Ò%Ú%ç%î%ñ%õ%û%ÿ%& &&&& &&&+&1&4&;&A&E&H&L&Q&X&]&b&&&&&&¡&¥&«&²&¶&º&½&Á&Å&Ê&"JohnDoe""QUASAR""SYSTEM"'C''C'.'FILES''Visual'chkdsk'.'config.sys''hidde'or_log.dat''or_log.idx''read'system'.(4).(Ambiguous(DBA.EXE)(Database(EXAMPLE(Invalid(Parser(SQL.(SqlCursorOpen)(SqlExecute)(SqlFetch(SqlLogin)(SqlLogout)(i.e.(usually) to receive the record's data. Set the*LPSQL*PSQL, created a. The. This. YouA call was made to the Quasar SQL API whereANSIAPIAPI.API?AdministratorAllAllowed)An attemptAnyAutomatic CommitBINARYBOOLBasic'Basic'.Be sure to use theCHARCOMMITCREATECallClassCodesColumnCommentsCommitConstControlCorruptCursorDECIMALDOSDataData ClassData FormatData StructuresData TypeDatabaseDeclarationsDeleteDescribesDescriptionDo not tamper with this field.DuringEachEach time theEditorFARFROMFieldFormatFunction: SqlFunctionsGlobalGlobal ConstHANDLEHowINSERTINTEGERIdentifies theIdentifies the cIdentifies the cursor which owns the result table in which the record exists. TheIdentifies the user who owns the cursor. TheIdentifies the user who wiIf a numeric column,If a result table is not associated with the cursor an error will be generated.IndIndicates that the data type of the column is invalidIndicates theIndicates whInstructs the Quasar SQL APIInvalidJohnDoe.Inventory;LIKELPSQLCONTROLLPSTRLengthLogs an user oNULLNote,Once these steps are completed, you can make unlimited calls to any of the Quasar SQL API fetch functions without repeating steps (1) through (4). The sameOneOnlyOverviewPASCALParameterPartPhysicalPhysical position is the raw position of the record in the file. Physical order is not the same as the order you specify with the SQL ORDER BY clause.PleasePoints toPoints to a buffer provided by the caller to receive the formatted record. This buffer must be at least as large as thePoints to a null terminated string containing thePoints to an SQL Control Structure. Any errors that may occur cause thePut the Quasar Database Administrator (DBA.EXE) and Quasar SQL API (SQL.DLL) someplace where windows can find them (usually in your windows directory).QuasarQuerRecordResult CodesResult TableRetrievesReturn ValueSELECTSQLSQL.SQLCOLUMNSQLCONTROLSQLSTATUSSQLTABLESUM()SYSTEM.SetSqlCursorCloseSqlCursorOpenSqlDescribeColumnSqlDescribeTableSqlExecuteSqlFetchFirstSqlFetchLastSqlFetchNextSqlFetchPositionedSqlFetchPreviousSqlGetStatusSqlLoginSqlLogoutSqlTable.lNumberOfRecordsSqlTable.nRecordSizeStatusStructureStructure.StructuresSyntaxTABLETableTheTheTheThe return value is 1 if no errors occurred and the table had at least one record, otherwise it is 0.The return value is 1 if no errors occurred, otherwise it is 0.The return value is aThe usual procedure for using theThisThis is an internal error which should never occur. Please contact customer service.This result code will not occur.This section gives an explanation of all result codes returned by the Quasar SQL API. This section includes a formal description of all constants defined in the Quasar SQL API include file for 'C' and the global file for 'Visual Basic'.This section includes a formal description of all data structures which your program will use when it communicates with the Quasar SQL API. TypeType/DescriptionTypedefsUSERVARCHARValueVersion)WORKWhenWhen theWhen youWhileWindowsYou_lclose()_lcreat()_lopen()accessaccordingly.adjustadministratoraggregateallalloallocatealreadyalsoandandandand adjust theand executed a queryanotheranyappearapplicationareargumentassociatedassociated with theattemptattributeautomaticallyavailableb-treeb-tree file managerbRightJustifiedbackbeenbeforebetweenbind managerbufferbytescalculatecallcalledcallercallingcallscancancan be reused for all fetches. Note, however, should you change thecannotcarrycausechangecharcharactercharacteristicscharactersclausecloseclosingcodecodescolumncolumnscombincommitcommittedcommittingcommunicatcompcompleteconditionconstantsconstrcontactcontainedcontainingcontainscontentsconvertedcorrupted.creatcreatecreatedcurrentcursorcursor.cursorscustomerdFielddatadata structure is set to one of these values as a result of andata structure.data.databasedatabase managerdatabase.declareddefineddefinitions can be found in the global file for 'Visual Basic'.definitions for all result codes can be found in the Quasar SQL API include file for 'C'. deletedescribedescriptiondescriptivedetecteddeterminedirectdiscovereddoesdouble dFielddropdumpdump managerduringdynamiceacheffectivelyeitherelapsedelementencounteredencountered illegal settings in the header portions ofencountered illegal settings in the header portions of a data file. It is likely that your DOS files are corrupted.enoughenterrorerror.errorsevenexampleexceedexecuteexecutingexecutionexisted!existingexists.explanationexplicitlyfetchfetched.fetches.fieldfieldfield offield of thefield of the SQLCOLUMN data structurefield of the SQLCONTROL structurefieldsfields of the SQLCOLUMN data structurefields of the resultantfields of this structure to be loaded with descriptive information.filefile'sfile,file.filesfirstflagfollowingfollowsforformalformatformattedfoundfromfunctionfunctionfunction call.function is as follows:function.function. A result table must be associated with the cursor. A result table is created when a query containing an SQL SELECT statement is passed tofunctionsgeneragivengivesglobalgreatergroupinghCursorhUserhUser , hCursor , lpSqlControl , hUser , lpSqlControlhandlehashaveheaderhelphowever,identifillegalimportin theincludeincreased.indexindicatedindicatesindicates that one or more result table records are available, allocate a buffer sufficiently large (at least as large asindicates.informationinformation.initializeinsertintendinterestinterfaceinternalintoinvalidis itsitselfjournaljustifikeylNumberOfRecordlRecordPositionlReservedlTimeElapsedlanguagelargelastleastlengthlibrarlikelylinklistloadedlocatedlogloggedlogginglogilonglpRecordBufferlpSqlColumnlpSqlControllpSqlStatuslpSqlTablelpstrQueryTextlpstrUserNamelpstrUserPasswordmSqlDataClassmSqlDataTypemSqlErrormSqlFlagAutoCommitOnLogoutmSqlFlagFormatPaddedmSqlFlagFormatStrmSqlMaximumNameLengthmademakemanagermarkedmatchmathematicalmaximummaymeanminimummodernmodifiedmoremostmustnColumnSequenceNumbernDataClassnDataTypenFieldWidthnHiLiteLengthnHiLiteOffsetnNumberOfColumnsnPaddingnPrecisionnRecordBufferSizenRecordSizenResultCodenScalenamenamesneednevernewnextnonenotnullnumbernumericoccuroccur.occurredoffoff.offendingoneonlyonly',openoperatesoperationoperatoroptimizoptionoption, set theoptionalor orderotherwiseoutoverownspaddparameterparameterparameter accordingly.parameter must have been created with theparameter to point to this buffer and set theparameter to the number of spaces you want between fields.parameter to the option you intend to use. If you have selected theparameter to the size of the buffer.parameter, you must call SqlDescribeTable to calculate the newparameter. parameter. The data in this record is formatted and loaded into the buffer provided by the caller and pointed to by theparameter. The description is loaded into theparameter. Toparameter. To fetch this record you must have alreadyparticularpassedpasswordperformpermanentlyphrasephysicalphysical positionpointpointedportionpositionpowerprecisionpredicateprefixpreformedpreviousprobprocedureprogramprogrammingprovidedqueryquery managerquery,query.rangereadreadsreallocatereceiverecentrecognizerecommendrecordrecordrecord bufferrecord.recordsreferencereleaseremoverepeatingrepresentresource,responsibleresultresult tableresult.resultantreturnreturnedreusedrightrolledrunsamescalescrollsecondsectionselectselectedservice.setsettingsetting in thesetting, reallocate thesettingsseveralshouldsimplesimplysinglesizesomeonesomeplacespacesspecificationspecifiedspecifystartedstatementstatement.statementsstatusstepsstringstructstructurestructurestructure indicates.structure isstructure pointed to by thestructure.structuressubquerysufficientsuresyntaxsystemszColumnNameszErrorDetailszErrorMessagetabletable.tablestagSQLtampertargetterminatterminatedtextthanthatthethemthentherethesethingsthisthreethroughtimeto determine the characteristics of the result table. Of particular interest are thetopictotaltransactiontransactiontransaction journaltypetypetype is a grouping column.typesunderunderlinedunits.unlessunlimitedunsignedunsigned longupdateduseusedusefuluseruseruser'susersusingusualusuallyutilizevaluevaluesviavisiblewFlagswantwaswhenwherewhetherwhichwhichwhich contained an SQL SELECT statement.whilewhowhosewillwindowwithwithinwithoutworkwrityouyourzero} SQL/ & ;) z4 gn missing. C ÿÿ
ÿÿÿÿ|CTXOMAP gÕ |FONT ÔÏ |KWBTREE ¨Ö |KWDATA rÕ |KWMAP Ö |Phrases |SYSTEM + |TOMAP ÓÎ |TOPIC L+ |TTLBTREE ×Þ
your
your
your
your
your
your
your
your
your
your
your
your
your
your
your
your
yourself
zero
ork
work?
written
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
you
c:\temp\scratch\meg15 >IÛwùÎ
à.9 window
window
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
with
within
within
within
within
within
within
within
within
within
within
within
work.
would
would
write
written
xxx
xxx
you
you
you
you
you
you
you
you
your
your
your
your
your
your
your
your
your
your
your
your
your
your
zero
zero!
{
{
{
{
{
}
} SQLCOLUMN;
} SQLCONTROL;
} SQLSTATUS;
} SQLTABLE;
w6 - l > >)
Quasar ÎK=U* ÝKü
Þ[ £ ~£ ÿÿÿÿ ÿÿÿÿ+ + !  ÿÿ M9 + 9 % T* ÿ MHelp Êex * 9 * - , ¾JBÑ à: ÿ aTs s ÃͲs G)(API). Using :board, tab to /]to view, n press er. Using mouse, -to /]to view, §click left mouse button. Use bar to see ries É0ly Y
t. To learn how to =, press F1. º í * º 4 : ¾JRB°±S~±á ÿ ì This Ts, in æl terms, what M0and how might =it to Âs yD. Examples µÃboth in $C.*) §
c$B.*). z ; º z v ¾ ÂJRB±S~±á á á á ÿ ® This s a ÏWof åiEcan ×MoSNy *LIB, DLL). Prototypes Íåçbe Õ
M»Í*H) §í»Í
c*GBL). zants h k p Íse Ýçbe Õ
M»Í çbe Õ
í»Í
d
g Macro Q ² N 0 z 0 ! â Mexplained' 0 ' " T* ÿ ì > ' > * & ²JRB!ã~! ÿ What 0the P Þ à > Þ ) $ ²JB!Ñ ÿ WM0a 4ful tool enables , software developer, to ÿfull to a , highly êed Kstandard F: R. r Ds ~ten in ¯EiçoSNies ç¡O These Ds , 'C++',
b, 'Pascal' §assemblers. In fact, ¯EiçMicrosoft environment çO Microsoft 50a oSNy. WM0your gateway to database technology. With a little a dozen å§ß4 data Ýcan #almost ¯database task. < $ Þ < * & ²JRB!ã~! ÿ ·cM|? d < ( " ²JB!Ñ ÿ "How 0this done?" might ask. Well, mS0sophisticated, complex §fully êed Í"ance: M0simple §straight forward. WMsÔs ×complex tasks of parsing, Kanalysis, Kêation, Ktree uction, etc. A ' A * & ²JRB!ã~! ÿ ·do I Sto P ^ q A j ( " ²JB!Ñ ÿ }Gin Ï Î , ¿to do ßto 5of in ²: ¯ D j ¯ / 0 ²JRB±s± ÿ 1) Sobject modules, LIB Ny along wLIBW.LIB. 2) Include H »(e.g. "#include
b, ¿to do ßtwo to 5of in ²: ² b ² 9 D ²JRB±s± ÿ 1) gGBL »d wO Note style :es ?wvariable ½7' n ' in ¶, §' sz ' in ì) µÉ?w
d 2) > # ² > * & ²JRB!ã~! ÿ ·do I =P ø > ø f ²JB!Ñ á! á á á á á á á á á" ÿ r Ecan `n to S 2 , ãa 3 , §a K . CK50passed to Mas a ÿÌ. WMc}Í. To get answers Ë(from a Â, Í) ¯¡Ýat a ×O can ¡Åe 0First) , Ie 0Last) , Åe 0Next) , ?e 0Previous) òeven a eat a 3¿ 0Positioned) . can ÿ©7ãat a so çdata way \. 're done, ý7 (SqlCursorClose) §[ù 4 . D ) ø D * & ²JRB!ã~! ÿ ·çI check ùmy Âs? : Å D : ( " ÂJB!Ñ ÿ can check ùÂs Ky £(QE.EXE) d wO Wy £allows to '
KE0going to send to M§ÿit re in front of . 'll get results Ëon screen ccan verify it's what expected. In fact, y £uses Mway Eb. 2 " : 2 ! ° Måexplained' 2 ' " T* ÿ ® < Î ' < @ R ¾JB!Ñ á) á ÿ UMåQa common structure to maintain generic : . Uåload Y -structure «an arise. Wbasic É0the ¶ field of A UMåfield to appropriate {
t of an Note: UMåclear field to 0 at ry . d B < d : F ¾JRB°±S~±á à2 ÿ & Closes a 2 ait 0no ber ¾ed í d ¼ J ¾JRB±S~±á à6 á à9 á E © °
á á á á á á à5 ÿ ( Opens a 3in preparation Ía J * an individual
| , úall ÷of | . Causes Eto a K§potentially -a | 0 Årecord ×| 2 Irecord ×| 4 Årecord ×î 8 ?record ×| 6 a record ×|. Wrecord 0identified by 3absolute *
î Á P r ÂJRB±S~±á á! á" ÿ : Gets É concerning IKd < ànto E > àff E 2 " 2 ! Mexplained+ 2 + " T* ÿ zants d + d ' ¾JBÑ ÿ h gUby »as ÏU(and @ably r) ñ
Åoof N \ Z d \ = L ¾JRB°±S~±á# à9 ÿ ½æl ÷of a
| ö \ ö ^ ÂJRB±S~±á$ á% á& á' ÿ ½ ÷of a
| Óas to Ñof =
| \ Óeto òroll ˯pending !at
í»Í
d x } e x : F ¾JRB°±S~±á( à9 ÿ W=structure iTs a
| i_æted by of a J n x P r ÂJRB±S~±á) á* á+ ÿ W=structure i# ¾ed by Mto #3å§ipasses process Ëto
* ! õ Open a 21 * 1 " T* ÿ ¬CursorOpen F E 1 F 1 4 ²JRB!ã~! ÿ L µ¥ï(( ù ) Õ F : F ²JB!Ñ à2 á! á ÿ afunction ,s a 2 G-a 3after ÿ]in 2 §Ïa K . Gcan -as many 7as ¿Í². 3 3 + ( ²JRB°ÑS~Ñ ÿ ð n ¸ l 3 ¸ f ²JRBÑS~Ñ á! á) ÿ ô ´ ½
| » ò Ù f Ua ÿ]in 2 A3 , §d a K . j 3 Í 3 + ( ²JRB°ÑS~Ñ ÿ ð n 3 ¨ " ²JRBÑS~Ñ á! á á á) á( ÿ ô ´ ½
Kþ, a | 0created §» ò a Kÿ]in 2 §/a 3 , . 3 ê 3 + ( ²JRB°ÑS~Ñ ÿ ð n 3 , ²JRBÑS~«' Þ' & Ñ á! á á) à7 ÿ ô ´ ½
aan k{Å Be ãto vital Ã`ever ]Eto %modify H ì µ ì G ` ÂJB!Ñ à9 á" á& ÿ Each
Z h parameter a[Ùëin case µ s Á
at logout, §n ßif no ÿÔ. - ì - ! þ Fetch Åd1 - 1 " T* ÿ ¬FetchFirst H b 1 H 1 4 ²JRB!ã~! ÿ L a¥ï0( ÷e ) Ú H Ú R v ²JB!Ñ à9 á! à2 á á ÿ afunction WÅrecord
| » ò W=in record 0formatted §W-Õ/to by d ]in 2 A 2 , §d a K . j 3 Ú 3 + ( ²JRB°ÑS~Ñ ÿ ð n ) 3 ) ²JRBÑS~Ñ á! á á á) á+ ÿ ô ´ ½
| ï ® h
2) o . . 3) o , ´ §
| ï ® h
2) o . . 3) o , ´ §
î, ÷it 00. v ö : Q ¢ : . . ²JB!Ñ ÿ _ 6 Þ - x : - ²JRB±s± á% á% á á á+ ÿ 1) %
Z h
| ï ® h
2) o . . 3) o , ´ §
| » ò d =at KÝ 0 ò 2 ò 6 à 3 3 + ( ²JRB°ÑS~Ñ ÿ ð n ) 3 ) ²JRBÑS~Ñ á! á á á) á+ ÿ ô ´ ½
| C ¢ ? * Ü p c w p . . ²JRB°Ñ3}Ñ ÿ tAPPROXIMATE Êicates 0one of approximate Ïdata &s ë G p ë F ^ ÂJRBÑ3}Ñ ÿ tBINARY Êicates 0of binary data & tCHAR Êicates 0one of õÍdata &s tEXACT Êicates 0one of exact Ïdata &s tINVALID Ì * ë * ! ô # % Data '/ * / " T* ÿ zants: u ñ / u > N ²JB°Ñ à9 á( á ÿ WÉy ÷of a
| C ¤ ? * Ü ~ u ~ 4 : ²JRB°Ñ3}Ñ ÿ vBINARY Êicates data 'of 0BINARY: 3M0given by ° ® U â ~ U Þ ²JRBÑ3}Ñ ÿ vCHAR Êicates data 'of 0CHAR: 3M0given by ° ® vDECIMAL Êicates data 'of 0DECIMAL: 37§µéby ° § ¸ ´ vDOUBLE Êicates data 'of 0DOUBLE PRECISION: 370given by ° ® vFLOAT Êicates data 'of 0FLOAT: 370given by ° ® vINTEGER Êicates data 'of 0INTEGER: 370given by ° ® vNUMERIC Êicates data 'of 0NUMERIC: 37§µéby ° § ¸ ´ G ( U S X ÂJRBÑ3}Ñ ÿ vREAL Êicates data 'of 0REAL: 370given by ° ® vSMALLINU YW ¸S T Êicates data 'of 0SMALLINT: 370given by ° ® vVARCHAR Êicates data 'of 0VARCHAR: 3M0given by ° ® vINVALID Ì * S * ! $ & Data Ñ/ * / " T* ÿ zants: o / 2 6 ²JB°Ñ à9 ÿ }a record 0fetched × | by s of Ýof SqlFetch ä, Mloads record -a ÕIby user. Wrecord 0returned in Ýof ñÐs. The
cH. ¨s ±
=Ó
õin iy ±
|. Character &s µ'to ËýõÌs þed w¹to bring to Mof ¦ as Õ
A Approximate §exact Ï&s µ'to ir 'double' tation. A record !fields: i(10), º, (7,2) would ±as: . 8 . ( " ²JBaÑ ÿ Ï{ F 5 . F * & ²JB©Ñ ÿ ószField1[11]; d2; d3; , F , ( " ÂJBaÑ ÿ } 6 , 6 ! Þ % ' Automatic at logout/ 6 / " T* ÿ zants: \ } / } , * ²JB°Ñ á ÿ }a K0executed Wan . Ú, it 0not
§sbe Ëif
|. Its Ssbe to Ýof . ¤ ½ ÷of a
|. Its Ssbe to Ýof . ¦ WÍof õ2s guaranteed to hold Sof arecord 0fetched. If
Z h 0 | : ¦ 0set to ³of . If 0 ~ing : ¦ 0set to ³of plus ÝÍúing Ê. If 0 ~ucture §0numeric: ¦ 0set to ²of(double), if 0a õÍ&: ¦ 0set to ³of plus ÝÍúing Ê. \ T z ÂJRBÑS~Ñ ÿ ° Ç ° 0set to 7(as Mby K) of If a õfield, ° 0set to M(as Mby K) of ~ ¸ Ç ¸ 0set to (as Mby K) of If a ýc g Ia õfield, ¸ 00. ' ' ! : ( * }=Ò+ ' + " T* ÿ : A - + A * & ²JRB!ã~! ÿ MInterface }F v A v . . ²JB!Ñ ÿ W =Ó#ºs necessary to provide an )Ѳs Dmer §N ; ! v ; % T* ! ÿ &def ÏôCONTROL { ³ R ; ³ D Z ²JPBÑ~Ñ ÿ ò ê[65]; ò ì[257]; 6 ¨; 6 ª; 6 ®; 6 ²; 6 ¶; 8 >; 8 @0 8 @1 8 @2 8 @3 8 @4 WORD Z; ] W ³ ] & T* ! ÿ CONTROL; &def >CONTROL; &def far
|. If > 00 n no kÿÍ¢ @0 @1 @2 @3 @4 Z Wßof Ms field to desire·l Òn h d to be Pd mrecord ¡ä. W=Ñbe ðly ed K'|' éw \ Æ. ' ' ! k ) + E=Ò+ ' + " T* ÿ : 5 + 5 * & ²JRB!ã~! ÿ y EF m } 5 m 4 : ²JB!Ñ á ÿ W =ÓTs úall øcome of ] . çÍa é4 : m : % T* ! ÿ &def ÏôSTATUS { s ¶ : s 2 6 ²JPBÑ~Ñ ÿ 8
|. ´ ϳ(in Ö) of a ÕGto hold a record ed ×|.
"FROM" ûof a J, Eë]iof . To qambiguity, ="Tablename.ColumnName" òthe "UserName.Tablename.ColumnName" ä. é + X ÿv èw }v ²JRBÑ3}Ñ à0 à0 ÿ xBadEnvironment W Path ry
"win.ini" »0not properly ¼: it begin wa drive ier followed by a ':' §a '\'. A typical ry 0"c:\database". xBinaryNotAllowed }*ing a î, data '__¼, _data '0not allowed in n. xCannotActivateFile YýÍto a »i0unrecognized by Æ E0an + i«ÁÓ ù 9 xCannotCloseFile Æ ¼ed to ýua =»òan º, an This Oa @lem w ^ory structure, we a & Ú + & l ª ²JRBÑ3}Ñ à3 à; à0 à4 à0 ÿ xCannotCloseLog F ¼ed to ýuòthe " º, an This Oa @lem w ^ory structure, we a xCannotCreateDataFile Æ ¼ed to -a =º, an This Oindicates ¡Í
»«be xCannotCreateDumpFile j ¼ed to -a iº, an This Oindicates ¡Í
»«be xCannotCreateFile d xCannotCreateKeyFile Æ ¼ed to -a ;º, an This Oindicates ¡Í
»«be N k & N d ²JRBÑ3}Ñ à3 à; à0 à3 à0 ÿ xCannotCreateLog F ¼ed to -uòthe " º, an This Oindicates ¡Í
»«be xCannotDeleteFile Æ ¼ed to qua =»òa ;º, p() an This Oµý½¿¦. ùbe ãÇof Eºs µas án' ò'system'. xCannotDropTable F ¼ed to ga î, 3'use count' _ï! b xCannotOpenDataFile Æ ¼ed to ãa =º, an This Oµý½¿§òdeleted º. ùbe ãÇof Eºs µas án' ò'system'. Also, Sºs ßW * á N 6 ^ ²JRBÑ3}Ñ à0 à3 à; à3 ÿ xCannotOpenFile d xCannotOpenKeyFile Æ ¼ed to ãa ;º, an This Oµý½¿§òdeleted º. ùbe ãÇof Eºs µas án' ò'system'. Also, Sºs ßW xCannotOpenLog F ¼ed to ãuòthe " º, an This Oindicates ¡Í
9| ~ }v »«be xCannotRemoveTable F ¼ed to Sa »ma 'Toolbox Remove' database æ, p() an This Oµý½¿¦. ùbe ãÇof Eºs µas án' ò'system'. å 6 å J f ÂJRBÑ3}Ñ à1 à0 ÿ xCharNotAllowed Ò ¼ed to !an AVG() òSUM() function, it a·_a iòVARCHAR ! xCheckpointDetected d xDataFileCorrupted W Æ ~ = ? å = ! µ , . Wing of {óII #- Ô7 ; = 7 " T* ÿ óII #- Õ) K 7 K z Æ ²JRBÑ3}Ñ à3 à; à6 à6 à0 à0 ÿ xDatabaseCorrupt W F encountered §
0s of " º. It 0likely ºs µ( xDbaNotAvailable WMcould Éestablish ion wR. Is Ening? xDivideByZero J a divide by Ô. xDuplicateColumn J a 0called ùonce in a Ucit ç±ßonce. a can ßÑ
mOç¹Ä xDuplicateRecord W Æ [an ½to violate an UNIQUE aint. xExistingDataFile Æ ¼ed to -a =º, it a» ºs ßW 3 2 K 3 z Æ ²JRBÑ3}Ñ à0 à0 à0 à0 à7 à7 ÿ xExistingKeyFile Æ ¼ed to -a ;º, it a» ºs ßW xFileReadFailed Æ ¼ed to Ua º, _lread() an xFileSeekFailed Æ ¼ed to seek a 3in a º, _llseek() an xFileWriteFailed Æ ¼ed to ~e a º, _lwrite() an xGlobalLockFailed L ¼ed to lock a íw°Lock() òLockResource() an . xGlobalUnlockFailed L ¼ed to unlock a íw°Unlock() òUnlockResource() an . · Ç 3 Ã Ò ²JRBÑ3}Ñ à0 à0 á+ á) ÿ xImportParseError d xIncompatibleTypes Y_yKto #an çÑtwo ¶s q&s conflict. An 0adding a ÿÍto a Ì. xIndexExists Y_yKto -an q»0already >. xIndexUndoFailed Æ ¼ed to -an unique ;Sa dupa ¢ licate _Ô. W½to undo *ion failed. b xInitializationFailed Æ ¼ed to !3îs, a failure _Z. b xInsufficientBuffer Wrecord to be to M
Uof an ¹KcÉÍof U
SUòthe Íof fields
Þ. ? r ) ? Ò ²JRBÑ3}Ñ à1 à0 á á á á á ÿ xMultipleSelects ëÝÃÑya J. xNoColumnExists W Ò {a »iit could Éto a ïMy1scope. xNoIndexExists A DROP INDEX _¼ed ano xNoOldRecord Æ ¼ed to íùan 4 ò 8 function, it are _no 1i Åan 0 , 2 ò 6 . xNoTableExists of a Ka ï»_encountered iëbe Õ
database -0ly \-on
Ä xParserStackOverflow b xPrecisionConflict A ç_requested iwould {in loss of 6. xResultTableExists Y_to a !(COMMIT z) ma | _still â. Users ý7iÿan ¹}Ï
ting |. xScaleOverflow The of {of a çúflowed. xSecurityViolation < _Ýwan / p ò r . xSetFunctionsNested %åÉbe nested. xStarNotAllowed W* å0illegal a?wGROUP BY ú. < V ~ ²JRBÑ3}Ñ ÿ xSubqueryNotOneColumn }a ß0used as an ·to a 9it a ±©
T. xTableConflict The ùïof an ¸, DELETE òUPDATE KÉ¡±in a 'from' ûof a Þ. xTableExists Y_in a mOKto -a ïi xTooManyColumnNames WUof ½in an ¹Ãs Íof
ð xTooManyTablesOpen Y_to ãîs Íof îs ibe ãat Ý. xTrialSizeExceeded WÍof ts recorded
[ýed trial ³allotment. Further çsirrecoverably corrupt B ´ ÷ À z Æ ÂJRBÑ3}Ñ à0 à0 à0 à0 à0 ÿ xUserNotLoggedIn I ô cÉan user. xVariableHeaderMark W Æ ~ xVariableHeaderSize W Æ ¼ed to place a record in a 3Ü ü i_ÉG. b xVariableHeaderWrong W Æ ~ xVariableHeaderZero W Æ ~ xWrongVersion W Æ ý\d =§;ºs µstamped wa version i0incompatible w1n. ! À ! ! ù ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ Æ ÿ + & ÂJBÑ ÿ WS0made of ©Gfunction 1 éof se 0the Æ. It 0responsible Íìing ùlow level =§å^ly on raw ºs Y
E^ory. ! ! ! ÷ ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ Ò « î + « & ÂJBÑ ÿ WS0made of ©Gfunction 1 éof se 0the Ò. It 0responsible Íassociating `cal ucts
Kwactual H, îs §
H ! « ! ! ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ 2 ¹ + ¹ , * ÂJBÑ ÿ WMkeeps track of {of a Kby s of a 2 C 3É , ïc{of a be Ô, Vs Ísuch a î, 1record 3Í¡æs, etc. ! ¹ ! ! I ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ F ý Ä + ý & ÂJBÑ ÿ WS0made of ©Gfunction 1 éof se 0the F. It 0responsible Íìing ùhigh level =§åon `cal îs §. WGuses Çto k
raw ºs Y
E^ory. WG0also yÍpolicing s §#(or 'log'). ! ý ! ! Ì ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ j + & ÂJBÑ ÿ WS0made of ©Gfunction 1 éof se 0the j. It 0responsible Í*ing iº. ! ! ! w ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ * + + + & ÂJBÑ ÿ ö ! + ! ! ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ J B ( + B , * ÂJBÑ ÿ By J we ¯Ä ! B ! ! ß ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ L ´ + & ÂJBÑ ÿ WS0made of ©Gfunction 1 éof se 0the L. It 0responsible Íparsing K-3component parts. ! ! ! Ø ÿÿÿÿÿÿÿÿ+ ! A & ²JBÑ ÿ f XXXXXXXXXXË ª v ¥ A v & ÂJBÑ ÿ éof ¶s to M¡å0a ,er to a f. This 0the ÕiZs Ó%of a h ! v ! ! å ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ | Ò + , * ÂJBÑ ÿ Uqueries æte a ï!chosen j. This 0called | . Its %µÃto Ýat a Ýof M¡ä. ! ! ! ú ÿÿÿÿÿÿÿÿ.
! . & ²JBÑ ÿ bar « â . « & ÂJBÑ ÿ A bar °s at ¦/or bottom edge of a uq%´n't ly X. bar #two arrows §a box, iallow to yuòlist box. ! « ! ! Û ÿÿÿÿÿÿÿÿ+ ! + & ²JBÑ ÿ " Î + & ÂJBÑ ÿ A #0a pair of ºs ('or_log.dat' §) ~ten by F. The ##a record Íevery t iîd a ñto H ! ! ! ! ÿÿÿÿÿÿÿÿ! ! ! ! ÿÿÿÿÿÿÿÿ ø Î °
` s µ ] d Y ø" & «, ©1 j6 û9 k@ úC äG `N Q ¸S ¬X 8^ ` Ia h Zp Ås }v ¢ W ¼ µ ¬ ± ú Æ = Ë ª g¡ a¢ <£ ]£ A
Helv untered illegalpica ings in the heaCourier ions of a daelite e. It is likeprestige our DOS fillettergothic ted. gothicPS WrongVersiocubicPS e b-tree flineprinter TermBtHelvetica ager y Teavantegarde anager spartan etermined thmetro r data and keypresentation amped wAPL a version which OCRA compatible withOCRB current releaseboldPS # TermBtreeFemperorPS b-tremadaleine ager ÿ Thzapf humanist ible fclassic iating the lroman f onstructs inroman g ry with acturoman h , tables andtimesroman the datacentury # # TermCupalatino cursor I Thsouvenir SQL API keegaramond of the resucaledonia e for parsbodini query into iuniversity t parts. script TermRecordBuscriptPS record buffscript c of the argscript d the Quasarcommercial script ctpark avenue inter tocoronet d buffer. Tscript h tabase.
greek
scroll bar
kana
A bar that hebrew at the rightroman s bottom edge russian dow whose coroman u ren't compleroman v ible. Each roman w ar contains narrator l arrows anemphasis a query byzapf chancery cursdecor d The cursorold english status decor f ion, the tabdecor g the result cooper black ay be fSymbol he column deslinedraw for such amath7 , the current math8 CT * syntax isbar3of9 when used wEAN the GROUP BY clapcline mSqlErrorSubtech h tOneColumn i ÿ ÿ % Î Î Î °
] d Y ø" & «, ©1 j6 û9 k@ úC äG `N ` Q ¸S ¬X 8^ ` s Ia h Zp Ås µ }v ¢ W ] d Y ø" & «, ©1 j6 û9 k@ úC äG `N Q ¸S ¬X 8^ 8^ ` ` ` Ia Ia Ia Ia h h h h Zp Zp Zp Zp Ås Ås Ås Ås / & ;) i24 ÿÿ ÿÿ ÿÿ - i- ÿÿÿÿAPI Close a cursor Column data structure Ü Column name length Ø committing a transaction Ì Constants H Control data structure ì Data class ¼ Data format Ä Data structures ` Data type À Describe a column Describe a table Execute a query Fetch a particular record ¨ Fetch the first record Fetch the last record Fetch the next record ¤ Fetch the previous record ¬ Functions Get status ° Index Log off ¸ Log on ´ Logging out È LPSQLCOLUMN è LPSQLCONTROL ø LPSQLSTATUS LPSQLTABLE Open a cursor Overview PSQLCOLUMN ä PSQLCONTROL ô PSQLSTATUS PSQLTABLE Result Codes t SQL SQLCOLUMN à SQLCONTROL ð SQLSTATUS SQLTABLE Status data structure ü Table data structure Table name length Ô User name length Ð ëFÊáºÄPÓâyñöà uìâÐâÊÓÓÊöÂu$ëÑËÑËÙ÷÷à tóÃÌÆF Ùf _ZY[^égþ$þè _ZY[^éìý QNáÀùÀtmNá8ùt
ùtá0ù0uTöÇÀt ç?6 ;6 uèGýÆ 6 ÙöÛ<NQá ÁNèÁ è^ Yá8ùtùt.ñÉÁNè ë;Ná8ù(t
á8ù tè è$ ë Ì@ÛâÙÉØÑÙÉÝØÝ>
Y$ýé-ýÛ~N÷Áÿt!öFußnÛ~~ t é>@NÛnÃ3ÉNNNNNëèPF%Àô=À Xsè éÕüöÄ@u\Ì@ WVQSÛâ×> t>V NÙåÍØãÀóÀt á8ÉÅv
é~~~ÆFNÆFËÿ^[Y^_ Ý>
à S³öÄu8³öÄu1³¨u+³öÄu$³¨u ³¨u³¨u³ ¨u ³¨ u³¨@u . 0¹¡ u´LÍ![ÿ XÏ£ %<ÿ> t£ Ù. £
á Ã3À: t Ý> $? %ÿ £ Ã% > t Ù>
åó Á£ Ù. ÙüÙ.
Ã
Qåó
å& Uèê]
èg Ã% > t)Ù>
åó Á£ Ù. Û Ù.
¡ Ã
Qåó
å& Uèd]ÂÓè 6 ;6 uèæúî 6
à öÑ. ÍÂå?
ÍöÑ. ÷ÁÿßtÙéþûPU VìÅv ÀNNvÐèÐèÐèöÐ$ &Ä°S» ë ûP¸ ëûP¸ U VìÅvNNv)S3ÛTX;Äu(@%û0=Ù0u@<ðr@%ÿþ=Ûât @=ßàtÆ[^ ]XÏÆBÆpÆäÆÆDÆrÆäÆÆ4ÆbÆäÆÆ2Æ`ÆäÆÆJÆxÆäÆ ÆHÆvÆäÆÆ$ÆRÆäÆ ÆFÆtÆäÆfÉLÉ#Ù ÙFÉ@ÉTÉ^ÉVÈ9É`ÈjÈ9ÉÈ9ÉÈÈÉ/É É«ÈóÈÿÈ ÉÙÏåÔÂÑ0ÔÐ;ÕðÒÔÀØz×9ÉÕÉØzØÐØ÷Õ"Ú ÚÚÚÚÚ Ú9ÉsÞÞ¹ÝåÝ9É9/ & ;) Lz PIC |TOMAP |F ÿÿ É ÿÿÿÿ Quasar SQL API help index Î Quasar SQL API explained °
Quasar SQL API functions explained ` Quasar SQL API constants explained s Quasar SQL API data structures explained µ The meaning of result codes ] Close a cursor d Open a cursor Y Describe a column ø" Describe a table & Execute a query «, Fetch the first record ©1 Fetch the last record j6 Fetch the next record û9 Fetch a particular record k@ Fetch the previous record úC Get Status äG Identify yourself as an user `N Log off Q Data class constants ¸S Data type constants ¬X Data format constants 8^ Automatic commit at logout ` User, table and column name length Ia Column data structure h Control data structure Zp Status data structure Ås Table data structure }v The meaning of result codes Part I (Ambiguous Column - Data File Corrupted) ¢ The meaning of result codes Part II (Database Corrupt - Invalid Cursor) W The meaning of result codes Part III (Invalid Data - NULL Not Allowed) The meaning of result codes Part IV (Parser Syntax Error - Wrong Version) which the record exists. The
Identifies the
Identifies the user who owns the cursor. The
Identifies the user who wi
If a numeric column,
If a result table is not associated with the cursor an error will be generated.
Ind
Indicates that the data type of the column is invalid
Indicates the
Indicates wh
Instructs the Quasar SQL API
Invalid
JohnDoe.Inventory;
LIKE
LPSQLCONTROL
LPSTR
Length
Logs an user o
NULL
Note,
Once these steps are completed, you can make unlimited calls to any of the Quasar SQL API fetch functions without repeating steps (1) through (4). The same
One
Only
Overview
PASCAL
Parameter
Part
Physical
Physical position is the raw position of the record in the file. Physical order is not the same as the order you specify with the SQL ORDER BY clause.
Please
Points to a buffer provided by the caller to receive the formatted record. This buffer must be at least as large as the
Points to a null terminated string
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/