Search results for query: *

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 ?

...? 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 pdox*.lck files on Z:, and resetart using just one copy of Paradox to check things out. If you still get an &quot;index out of date&quot; error, then...

<<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...

...The last time one of these was released was in early 1995, so it's REALLY time to upgrade. However, for now, things to look for are as follows: * you never said what OS you're using locally; if you are using Windows 2000 or XP then you MUST set up compatibility for Paradox (apcompat.exe on...

Hi Carsten, Firstly, don't panic - I've seen these before, and they're _usually_ (tho' not always) due to file system problems. Could you test things and answer these questions for me, please: 1. Log in as yourself (administrator group, I suppose) at your own workstation and create these...

...r/w settings are unlimited, I've tried to rename the database folder and make a new one, restoring all files to the new folder, but I can't r/w *.db files at that drive. If I create a folder on my workstation, it works perfectly.&quot; Your first statement is flatly contradicted by your...

Having just read through the thread, I feel that I have to add this to what Lance the Footpad has said. I have developed in Paradox and Windows NT 4 and then Windows 2000 ever since Windows NT 4 came out. Aside from striving to use the latest version of Paradox, so as to minimise the shock of...

That info looks interesting - thanks for coming back with it - Mike I PS is that you, Lance L. ?