FiveTech Software tech support forums

While showing syntax, we enclose some parameters in square brackets to inform the programmer that these parameters are optional. Not at all that you should use the square brackets in real usage. NOT oBrw:bRClicked := { |r,c,f,oBrw| ...

... | <xDelimiter> ] ] [CODEPAGE <cCodePage>] ; DELIMITED WITH <xDelimiter> The WITH option specifies the delimiting character to enclose values of Character fields in. <xDelimiter> can be specified as a literal character or a character expression enclosed in parentheses. ...

Hi Anser,

Great work!

Is there also a way to get the words with emphasis? For example, I want to enclose all italic words in <italic>italic word</italic> and bold words in <bold>bold word</bold>.

Many thanks,
ryu ( FWH1706 + xHB1.0 + Pelles C + VS Code)

... fieldlist, aValues ) b) oCn:Insert( table, fieldlist, aValues ) c) oCn:Upsert( table, fieldlist, aValues ) Whatever way you write data, you can enclose in Beging/Commit Transactions; Make a separate function to Write. Example: function WriteAll()  oCn:BeginTransaction()  <write ...

... fieldlist, aValues ) b) oCn:Insert( table, fieldlist, aValues ) c) oCn:Upsert( table, fieldlist, aValues ) Whatever way you write data, you can enclose in Beging/Commit Transactions; Make a separate function to Write. Example: function WriteAll()  oCn:BeginTransaction()  <write ...

... fieldlist, aValues ) b) oCn:Insert( table, fieldlist, aValues ) c) oCn:Upsert( table, fieldlist, aValues ) Whatever way you write data, you can enclose in Beging/Commit Transactions; Make a separate function to Write. Example: function WriteAll()  oCn:BeginTransaction()  ...

... can also use BEGINMYSQL, COMMITMYSQL, ROLLBACKMYSQL. In any case, because you are inserting only one row in one single table, there is no need to enclose in Begin and Commit Transaction. FWH supports FWMARIALIB. Using this lib, we could write the above code as: nRet := oCn:Insert( "nombres", ...

... The DELIMETED option specifies the target file as a delimited ASCII file where field values are separated with a comma and Character values are enclosed with a delimiting character. The default delimiter for Character values is a double quotation mark. DELIMITED WITH BLANK | TAB | PIPE When ...

The case of memory file was not considered when making this part of the code in database.prg. Please enclose all lines from 289 to 295 inside an if condition "if ! Empty( ::cfile ) ........... endif" like this            if ! Empty( ...

... software. When table names of field names conflict with reserved words, the work-around we adopt is to escape the names. In Microsoft products enclose them in [] and for MySql `. Out adofuncs.prg automatically helps escaping the names suitably depending on the database. But in Oracle and PostGre ...

... it errors like that. Here with Mysql sometimes gives also error NOT Supported. Probably because there aren't any pending updates? My idea its to enclose it in TRY CATCH. with catch doing nothing. In all my trials with MySQL and oledb ADS doesn't seem to have any bad effect. What do you think? ...

// alias dbART ; Nover omit specifying the alias. This is a must for proper functioning. You need to enclose alias name in quotes. fields DBART->CODIGO,DBART->DESCRIPCIO, Please never use FIELDS. Only use COLUMNS. (We provided FIELDS clause only for very quick migration ...

... FoxPro evaluates expressions, functions, memory variables, and array elements specified with TextLines only if you set SET TEXTMERGE to ON and enclose them with the delimiters specified by SET TEXTMERGE DELIMITERS. If SET TEXTMERGE is OFF, Visual FoxPro outputs expressions, functions, memory ...

... to modify data in some other tables also. This is now achieved by including such code in the DATA bOnSave codeblock. Now, it is possible to enclose all the changes ( to the main table and other tables ) in a Begin and Commit Transaction. New DATAs: bBeginTrans, bCommitTrans, bRollBack DATA ...

... INT, AGE NUMERIC ( 2, 0 ), SALARY NUMERIC ( 9, 2 ), NOTES VARCHAR ( 70 ) ) FIRST and LAST are reserved words. If you must use them you have to enclose them in square brackets. 2) When the acces file is created , which code should be used to populate the acces file ? Something like this: FUNCTION ...