FiveTech Software tech support forums

... in examine the SQL statements, we can use METHODS InsertSQL(), ReplaceSQL(). Insert() method is very efficient and can handle multiple row inserts as well as update on duplicates. Even experts should find these methods very useful. TRANSACTION SUPPORT // ADO CompatibilityMETHOD BeginTrans ...

... are automatically seen in all the Clones. The internal linkage of the Clones does not work / broken in the following cases. a) Deletions and Inserts are not seen by other clones. (differs from ADO) b) ReQuery() of a Clone totally de-links it from other clones. (like ADO)

... METHOD SetMultiStatement( lOnOf ) METHOD max_allowed_packet_MB( nNewVal ) METHOD GetAutoCommit() METHOD SetAutoCommit( lOnOff) Note: Multiple row inserts are speeded up autocommit is disabled before insert and enabled after insert. METHOD Ping() --> lSuccess METHOD BeginTransaction() METHOD ...

... ) ; ACTION ( ::WndChild():Copy(), ::WndChild():SetFocus() ) DEFINE BUTTON RESOURCE "RTFPaste" OF ::oBar1 ; MESSAGE "Inserts Clipboard contents" ; TOOLTIP "Paste" NOBORDER ; WHEN ( ::WndActive() .and. ::WndChild:CanPaste() ) ; ACTION ( ::WndChild():Paste(), ...

Hi All, I have a new trigger in SQL which inserts a new record in another table, but I am getting a blowup Error description: Error BASE/1132 Bound error: array access Args: [ 1] = A { ... } [ 2] = N 1 Stack Calls =========== Called from: ..\source\sqlrdd2.prg ...

... Enhancement: SQL INSERT command. Now column names are optional. New: SQL INSERT INTO <table> [( <colnames> )] ARRAY aData for Bulk Inserts * Enhancement: Cuebanners of TGet and TEdit now support Unicode also. * New functions: StrToWide() and WideToStr(). Appropriately use Ansi/Unicode ...

... Enhancement: SQL INSERT command. Now column names are optional. New: SQL INSERT INTO <table> [( <colnames> )] ARRAY aData for Bulk Inserts * Enhancement: Cuebanners of TGet and TEdit now support Unicode also. * New functions: StrToWide() and WideToStr(). Appropriately use Ansi/Unicode ...

... * Enhancement: adofuncs.prg - function FWAdoCreateTable( cTable, aCols, oCn, [ lAddAutoInc := .t. ] ) Existing behavior: By default, the function inserts an autoincrement primary key column with the name "ID", if the aCols[ 1 ] is already not of type "+" This behavior can be ...

... select max otherwise we could have Lastrec() returning 20 and recno 35! Next question is how frequently we need to keep checking for other users' inserts. We can't keep checking continuously. If the reocrdset is ordered on the primary key, it may be enough to check when (i) DBGOBOTTOM() and (ii) ...

... such cases comparing the max() values indicates activity by other users. Next question is how frequently we need to keep checking for other users' inserts. We can't keep checking continuously. If the reocrdset is ordered on the primary key, it may be enough to check when (i) DBGOBOTTOM() and (ii) ...

... not fail. Table is the same ? Here that version its working. There must be something wrong with your config. Here all its working. ADO_OPEN it inserts field set to be used as recno as first field primary key. Do you have SET ADO DEFAULT RECNO FIELD TO .. defined?

... topics. FWAdoCreateTable( "test", { { "PROG", "N", 5, 0 }, { "NAME", "C", 30, 0 } }, oCn ) inserts one auto-increment column ID as the first column and as primary key. The resultant table will have 3 columns ID,PROG,NAME with ID as auto-increment ...

Enrico,

I think you misunderstood my question.

In my application, I open a RTF-file in Word, using OLE. Then I want my application to save it as a Word 1997-2003 document.

The solution you suggested (I think) inserts a rtf-file into a Word-document, doesn't it?

Thanks.

... to accept whole rule even if it was possible to find a valid match in differ way. 16. Result markers. <idMarker> Regular result marker - inserts matched result as is without any modifications. The first token inherits number of leading spaces from the result pattern. #<idMarker> ...

... after which the transaction terminates. Re-examine the INSERT statement on page ***. The statement by itself, not part of a cursor definition, inserts a single row into the customer table. In fact, the whole apparatus of the insert cursor can be dropped from the example code, and the INSERT ...