Search results for query: *

read my last post, technically correct but may be confusing to some users. should have been select table1 set order to date &&must have this index scan for date={01/01/2002} &&or some other statement scatter memvar insert into table2 from memvar endscan

set the order on the origin table first select table1 set order to date &&must have this index scan for date={01/01/2002} &&or some other statement insert into table2 endscan

do you need them all for your desired query? You can build many views depending on the need.

build a local view based on the remote views

I create different exe's all the time. I use it when I have a new version of my program that needs to go out for the next day. I place the new file (program and newprogram) in the same directory as the old version and I have a script that runs after office hours to change the rename both (old...

this doesn't have anything to do with the query but if a customer moves and changes their phone number you will have a problem. Better off assigning a customer id to each customer.

ODBC should be installed on the machine, it is not part of the exe

why class 2 public variables? Keep it simple and declare them public in the startup program. OR make them a property of the form.

"REPORT FORM XYZ PREVIEW" Never tried the syntax might be a problem, try "report form xyt to print preview"

On the next line after the seek would be: scatter memvar thisform.refresh

try this select [origintable] set order to scan for inlist(jobno,"NM7000","NM7001") scatter memvar if jobno=,"NM7000" insert into NM7000 from memvar tableupdate() &&if buffered else insert into NM7001 from memvar tableupdate() &&if buffered...

The textboxes will always have a value showing unless your pointer is setting on a blank record (assuming the controlsource are the fields in a table). There are ways around this, one method is setting the controlsource to M.[fieldname] then using scatter memvar and thisform.refresh to populate...

try IF EMPTY(THIS.VALUE) OR THIS.VALUE>DATE()-7 RETURN 1 ELSE Messagebox("INVALID DATE: Date Recieved cannot be More than 7 days prior to today.",0, "Error") RETURN 0 ENDIF

Hint: a remore view is faster than SQL pass through.

The executable will always look for the tables in relation to where it was compliled. compile the exe on c drive the copy it to the destination drive. as long as your data structure is the same as your c drive it will work just fine there.

even if yoy use sql server you will still need a front end and Foxpro works nicely. If it aint broke don't fix it,

all you have to do is select workareaalias set order to someorder go bottom if you get an error the index is corrupt

whats your update code?

I agree I find that like the wizards, frameworks just add a lot of unneeded overhead.

If you are in the project manager, 1. Drop a control on a blank form..Example textbox 2. Format the control as desired..Example change font 3. Make sure the control is selected 4. Go to File> Save as class 5. Save the selected control to the desired folder in your project (I always have an empty...