FiveTech Software tech support forums

... must be sent before a commit. The default is 250 but it can be changed. The best way to export data from dbf to an sql database is (IMHO) using transactions with a commit after them.

... If the User wishes to cancel the transaction before I commit the detail .. so be it. There is just a sequence gap in the committed Invoice transactions. Rao does have a GOOD point about using an AutoNumber on the InvoiceNumber field letting the database issue the next number, however using ...

... updates when the connection come back again. I hope this is possible. It seems that since the actual connection is lost any pending transactions will be rolled back. (this is with their server) I dont know if it is like this elsewhere. Thus we are going this way. Does anynone has ...

Guys:

I'm printing a statement of account type report where I need to print at the top of each page the customer's name, address, etc. BEFORE listing the actual transactions. How can I do this ? Thank you.

... still some adjustments to do. (MySql) Our client is working with the app with adordd in MySql in parallel with the same app with ADS comparing all transactions and behavior between the two. He s quit happy. (2nd week trials on real data) The app its more than 90% converted ( tested ) and we only ...

... happens (MySql) when you edit a empty date and save the same empty date. Thats why we didnt have found it before although the app makes lot of transactions but never in this circumstance. When the user in a browse does that errors. I know that expressions with numbers in SCOPES and perhaps ...

Lucas, In the app we are working browses are not a problem. All work well without a single changed line. My worry is with transactions. The app works 99% like this: First closes and add all records to all tables necessary to the trans. If all goes well loop through those records in ...

... This brings a problem because new and deleted records by others are not seen. Deleted records its not so difficult because in editions or transactions when we lock we do resync and if there is an error we requey and locks fail so edition or transaction doesn't not proceed. But with new ...

... Here is a sample. This sample creates a PROD_GRP table (which you referred to as catalog above) and a transaction table, SALES_TRN with 500,000 transactions. In the function CreateSummary() the program summarizes the data and updates the catalog table PROD_GRP. On my PC it took less than 2 seconds. ...

... adordd version with working locking as dbfs at https://github.com/AHFERREIRA/adordd.git This is still on trial and its working quite well on heavy transactions many records in many tables. It assures completely record locking and concurrent access control like any other rdd. The drawback is that ...

... you need to keep experimenting more on this, simultaneously working as two users on the same table. Starting a transaction can eliminate this ? Transactions and locking are two different things altogether. All updates within one transaction block either they get written or abandoned but never ...

... when preparing SQL statements comparing Dates. For example, SELECT * WHERE INVDT BETWEEN '2015-04-01' AND '2015-04-30' may totally exclude all transactions that took place on 30th Apr 2015. Because this is actually translated as INVDT >= '2015-04-01 00:00:00' and INVDT <= '2015-04-30 ...

Rick, Thanks for the info. Inside transactions if it fails everything rolled back, but its the only situation I can find where his happens. Are you trying adordd. All feed back its a great help. Im trying it for a big app conversion and browses ...

... support to generate pivot tables with a single function call. Viewing of pivot table is again a simple one xbrowse statement.. Excel Example: Transactions data: http://imagizer.imageshack.us/v2/xq90/537/KWX1wp.jpg Excel Pivot Table from this data. http://imagizer.imageshack.us/v2/xq90/537/HnIa7M.jpg ...

... from last week once the aplication was closed, data were lost . Antonio L., please wait to the announcment. Thank you. Lucas, The problem is with transactions please check adorrd.prg and try inhibiting transactions or try issue dbcommit() and check if it is ok. Replace Im trying it seems to be ...