FiveTech Software tech support forums

... where nextVal() ( NOT currval() ) is used when INSERT new Record As I said in my earlier post, it is always good to have a SERIAL primary key. RDMS will take care of nextval() or currval() and it is not other botheration. RDMS will safely append even hundreds of records per second. No worries. ...

If you are using DBF via DBFCDX, use memo fields. ( DataType 'M' ) If you are using any RDMS use BLOB fields. DBF: FIELD->IMAGE := MEMOREAD( "picture.jpg" ) RDBMS: oRs:image := MEMOREAD( "picture.jpg" ) If you are browsing in XBrowse, ...

If you are using DBF via DBFCDX, use memo fields. ( DataType 'M' ) If you are using any RDMS use BLOB fields. DBF: FIELD->IMAGE := MEMOREAD( "picture.jpg" ) RDBMS: oRs:image := MEMOREAD( "picture.jpg" ) If you are browsing in XBrowse, ...

... FWH instead of opening on our own with ADODB.Connection. If we open using FWH function FW_OpenAdoConnection, all the other ADO functions know the RDMS used and function in a say appropriate to the RDMBS. Please try this:   lDate    := STOD( "20230101" )   hDate ...

... Rock solid. No index maintenance is needed. Takes full advantage of both ISAM (for browses) and porting legacy code and at the same time SQL of RDMS with the great power for complex queries. Calculations are done on the server and only summary comes to server reducing network traffic and also ...

... can do it in two ways. (a) Directly using SQL. (b) Opening recordset in batchmode. (a) Directly using SQL. SQL syntax is different for different RDMS like MYSql, MsSql, Oracle, etc. It is also extremely cumborsome to prepare SQL statements. You might have seen lots postings as to how to prepare ...

... looking to migrate your application to MSSql .. I would like to offer my help .. As you know, I have been using ADO for many years and my favorite RDMS is Sql Server for Enterprise applications and MS Access for local portable applications. There are several ways to code your application using ...

... Moses comments .. there are potential opt lock problems with .dbf and certain networks ... I moved away from .dbf over 10 years ago to ADO and Sql rdms's .. YES, I had to re-write my programs to deal with SQL query syntax and never looked back and I have NO problems with performance .. To make ...

Oscar Have a look at in your FiveWin install under \function and have a look at the file adofuncs.prg .... a nice set of various RDMS SQL connection and recordset wrappers that Rao has put together .. Here is a link that may help in doing it the old fashioned way ... and understanding ...

... class derived from TDatarow class. This class works with not only TDatabase, but also directly with DBF, FWMariaDB, TDolphin and ADO ( with any RDMS ) also. To save the time of creation of base table on all these platforms, I have used "customer" table which is already present in all ...

... using ADO with either Ms Access for portable installs or MS Sql Server for Client\Server .. there are no record locks needed with ADO .. the RDMS is handled much differently .. I have never looked back .. and performance with ADO and SQL has never been an issue. Just my 2 cents worth ... ...

Enrico As you know with any RDMS you can create a Primary key as an auto-increment .. for example in MS access: cSql += "[InvDetailEid] COUNTER NOT NULL, " .. .. cSQL += "CONSTRAINT PK_INVOICEDETAIL PRIMARY KEY ( InvDetailEid ...

... the FiveWin brand. You bring to the table FiveEdit ( richtext ) which is the IDE ( need a resource editor :) ) and Rao brings to the table the SQL RDMS component for ADO ... re-packaged as a solid add-on component to C++ for Win api gui apps is where I would like to see the marketing focus ... ...

... of the FiveWin brand. You bring to the table FiveEdit ( richtext ) which is the IDE ( need a resource editor ) and Rao brings to the table the SQL RDMS component for ADO ... re-packaged as a solid add-on component to C++ for Win api gui apps is where I would like to see the marketing focus ... ...

... the FiveWin brand. You bring to the table FiveEdit ( richtext ) which is the IDE ( need a resource editor :) ) and Rao brings to the table the SQL RDMS component for ADO ... re-packaged as a solid add-on component to C++ for Win api gui apps is where I would like to see the marketing focus ... ...