Recent content by dcpking

It sounds like you have the field indexed, which may be the cause of the slow response (multiple things happening per row updated). A standard procedure is to remove indices, apply update, and re-impose indices. hth Mike

If you are running v2000 or later, and if the text is actually within the tables, in the correct field types (see manual or online help) then you can use SQL Server for full text searching. However, if the items are held in binary form (eg as .pdf files within a binary BLOb) or held outside...

Where is your Paradox Net directory for each client ? Look at the Paradox FAQ on Net Rules and also the one on Operating Systems (treat your 2003 server as though it was a 2000 or Win NT system). Mike FAQs & TIPs: http://mirwin.homestead.com/Paradox.html

Do you have some other field covering the field you're trying to click onto ? In design mode, select it and then use the format menu to Bring To Front (or Top). Run it again to see if that fixes things ...

1. <<This calculation does not work correctly when i do it on the report so i have to use code.>> it should: please post the content of the calculated field in your report that should be showing the result of, say, the combination of a1 and a2, along with all the values in the line. 2...

As Lewy has pointed out, there's lots of Help on the table.restructure() method. However, I would give very serious thought to the desirability of doing this "on the fly". What are your reasons for doing this ? What are the risks ? What are the hoped-for benefits ? I would suggest that...

SELECT * FROM ACTIVITY WHERE ACTV_BEGIN_DATE = #27-Aug-2003# have you tried something like SELECT * FROM ACTIVITY WHERE ACTV_BEGIN_DATE = &quot;08/27/2003&quot; which is a more normal date format ?

did you clear your problem ? If not, what OS are you usiong to get filenames Z:\DBS\WOFFMEM\PDOXUSRS.LCK.FILE: Z:\DBS\WOFFMEM\PARADOX.LCK.TABLE:wm2 ? Z:\DBS\WOFFMEM\PDOXUSRS.LCK Z:\DBS\WOFFMEM\PARADOX.LCK should be what you have. Normally, you should get all users to log off, delete all...

<<The sendkeys function seems to be restricted to an application that was started by the Paradox Execute command which won't be the case for the dialog popup. >> not so, actually. Just the program with focus, as it just stuffs the keyboard buffer. Use enumWindowNames() and enumWindowHandles()...

<<When I created the script from within the Paradox environment I was able to run it without the error.....must be something that the Paradox environment does differently. >> Paradox for Windows deals with Objects. All &quot;things&quot; are variations of a single Object. Forms have a surface...

&quot;append a live table&quot;. I believe what you mean is &quot;to append records to a table in use by someone [else]&quot;. Assuming that ... Assume that your tables have a single-field primary key called, for our purposes, &quot;PK&quot; var tcMyNewData tCursor tcLiveTable...

Known bug. Recommended Solution: upgrade. Alternative: Code around the problem. Look at the example of code to use on the form that invokes the lookup at http://mirwin.homestead.com/files/tips/DIYLookups.html I haven't shown an example of the lookup form itself (called luVendor.fsl in that...

Many thanks everyone - I got it to work fine ! One interesting thing: the first time I did it I put the {table.id} = Switch({?Parameter Type} = 'ID',{?Parameter Value}) Or {table.name} = Switch({?Parameter Type} = 'Name',{?Parameter Value}) into the Report | Select Expert | Show Formula...

I'm using CR 9.2.0.448 based on MS SQL Server 2000. My company is a REIT, dealing with malls. We identify a property either by number or by name - both varchar fields. I can create parameter inputs for either one, but some users want one method (by name) and some the other (by number). Can I...

One last possibility: check that your workstations have the latest Novell client software installations - from Novell, not MS ! If it still doesn't work, and if you _are_ using compatibilty on the XP machines, and if there is only a small amount of disk available (5 GB may well cause any 16-bit...