Granted, most of my work uses the BDE, however, I cant imagine that Intersolv would release a driver that didnt allow for that possibility. (Of course, stranger things have happened.
![]()
Paradox Database Query Tool Driver That DidntParadox Database Query Tool Drivers That ResolvesHowever, it appears as if Intersolv has an update to their ODBC drivers that resolves some issues with WHERE clauses against Paradox tables. See for the details). Hope this helps. -- Lance P.S. Paradox Database Query Tool Software Provided WithGenerally, this forum supports Paradox for Windows, the database software provided with Professional editions Corel WordPerfect Office 2002. While a few of us are also skilled in other areas, its always best to try to post in forums related to the actual tools your using. Im not sure if tek-tips has an InterSolv area, but you might see if theres one for your specific tool. You might run into someone whos run into the exact same issue. The client is a program that uses an SQL panel that allows you to (1) enter SQL code, very much like MS Query or (2) enter a call to a stored procedure within a RDBMS database, such as Paradox. The SQL statements Im using updates a flag on a table, then selects rows on that table by that same flag, and then deletes the rows on that table by yet the same flag. Below is the code Im using: Update set flg Y where flg N Select from where flg Y Delete from where flg Y If possible, I wouldnt mind calling a procedure from the Paradox database that can perform this same SQL, as long as a result set is returned from the Paradox database. As I said before, when I perform a single Select from where flg N, rows are being returned to the client program with success. Its only when I add the Update.where and Delete.where that Im having a problem. Can you provide a sample Paradox procedure that can perform the UpdateSelectDelete for me Please advise. I would love to be able to give you a stored proc, but theres no support or mechanism for doing so outside of the client program used to access the data. You could use something like Paradox for Windows, dBASE for Windows, or even a custom utility written in Delphi, C Builder, or even VB for that matter. But, Im afraid the administration tools provided with the BDE dont include the type of thing youre looking for. Im not sure, but you might check your client tool to see if they provide any properties or the properties of your ODBC 32 Data Source to see if there are some concurrency settings or something like that. Beyond that, all I can suggest is seeing if there are related issues and or information available from Intersolvs website. Sorry. -- Lance. Youll have a better idea about the possibility of that than I do, Im afraid. I do not believe Intersolvs driver supports DDE, OLE, or any form of IPC. Though you certainly get points for creativity.) The problem is, of course, that we have no idea which client youre using. I dont believe you should be having problems running multiple SQL queries in series. I know Ive had no troubles doing similar operations from Paradox for Windows or any Delphi clients Ive written. Granted, most of my work uses the BDE, however, I cant imagine that Intersolv would release a driver that didnt allow for that possibility. Of course, stranger things have happened.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |