Search results for query: *

used to be able to debug in the past, but since we moved the app to windows and I'm compiling in Wndows XP, I'm not able to debug using Alt+D, nor ALTD() in code, nor CLD.exe. I compile fine with the debug option but I cannot run the debugger. Please help by providing steps to compile with...

Thanks... You made my day. I'm looking for success stories to advance my case. Thanks again clip4ever

I was afraid this is the case. Thanks

Question: I loop and read a set of records from a table. If I restart and read the same set of records again, does this cause another trip to the database or the program uses the records retrieved earlir ? Thanks in advance clip4ever

We have several Clipper 5.2e APPs still running. 6 of them are critical 7/24. 1 critical APP has just been developed and deployed last month. They are going to stay for long Time (years). More functions are still being added to these APPs for 2 main reasons: -- Cost. -- Performance. Clip4ever

I'm not sure this is the case, but if you have C programs that deal with COM ports or checks the Serial Port, it is different in XP. XP does not allow checking the DSR in a C program. clip4ever

We are planning an upgrade to use Advantage Database Server (ADS by Extended Systems-Sybase) for our App that uses DBF/CDX. Is there Anyone who did this conversion? Any tips ?, i.e.: -- Recommended or not? -- Does it really improve parformance dramatically as they claim? -- DOs and DONT's...

All, As a feedback on my experience with this problem, we implemented CDX index and the response Time improved dramatically in on-line and batch programs. However, we had some side effects that we are still working on, like a highly used batch server program crashes often. By putting some delays...

Thanks. But pack cannot be used in on-line applications because it requires exclusive access. clip4ever

Griff, Ok, I know my mistake now. I had to include this UDF in the index program and in a library used by many other online and batch programs that are accessing the same db but compiled in different EXEs. I replace the CHR(255) with "z" and added 2 spaces at the end of this particular index...

Griff, How do I do that. I'm including the function in the same re-index program. Do I need to include it somewhere else ? or define it ? Clipper does not recognize other than clipper commands and database fields in an index expression. Clip4ever

Griff, This code does not work because Clipper INDEX ON needs and expression to evaluate not an index value. Regards clip4ever

Interresting... I'll try to get approval... Thanks

Thanks again. I'll find out what are my chances in doing this in Production. clip4ever

Here's the Index expressions/code: ---------------------------------------------------- DO OPEN_FILE WITH "ITMSCAN","ITEM SCAN" DO INDEX_FILE WITH "rcp_id + STR(seq_no,5,0)", "ITMSCAN" DO INDEX_FILE WITH "pin + status", "ITMPIN" DO INDEX_FILE WITH...

Gents, There is no SET FILTER, nor SET RELATION. By scanning a barcode, the code writes the previously scanned pending barcode + info to one table, then reads the next barcode, performs validation (reads) on 2 or 3 tables, prints a label, the waits for the next scan. Table is normally...

Inerresting analysis. However, in my application, I open all databse tables in shared mode when I enter to the main menu and they all stay open until I exit back to the signon screen where I close most of them keeping a couple of control tables necessary for login. According to your analysis...

Jim, Deleting the NTX is an inerresting idea. I'll try it. Re-creating the indexes here and there and every night is not possible because it is a 7/24 application and I need an outage in order to re-index or do anything. A maintenance release is coming in a week or 2, and I'm convinced to try...

The weekly Purge and reindex activity includes: -- Deleting records older than a specific date. -- Packing the tables. -- Indexing the database tables using the INDEX ON statement, whic I believe recreates the index. If you mean phusically deleting the NTX file using the DOS delete command...

I came across CDX before when I upgraded to 5.2e but declined it because it required extensive changes to my app. I will have to reconsider it again since you believe it will help. I will also inquire on the Advantage database and I welcome any tips lessons learned about it in order to try to...