Search results for query: *

The following code I have is in the click event of a list box. When the dispatch_num is found in this one table, it is supposed to send the info into another listbox. The problem is that it can only find the first record in the table. LOCATE FOR stopovers.dispatch_num = update_disp IF FOUND()...

How do I get a variable displayed in my messagebox text?

Whenever I use the following statement, a stupid window pops up with the query results. How access the record w/o having the window pop up? SELECT * FROM mileage WHERE mileage.ref_id = cur_ref_id WITH thisform .txtdr_miles.value= miles .txtpu_city.value= origin .txtdr_city.value=...

when I click on an object that requires info from a table, it comes up with an error [tablename] alias not found; however, when I click ignore, it brings me to a list of tables and I can choose the table from that list. After that, I don't get errors and the program has no trouble finding the...

I'm still a little confused on my delete button. Instead of it deleting the current record, it deletes all the records in the table. Can you review my code and tell me what I need to change? thanks in advance. lcchoice = "" lcchoice = MESSAGEBOX("Are you sure you want to...

thanks, homie

What is the inkey() value for the decimal key (or period)? It doesn't seem to be listed in the help menu.

Dumb question... How do I switch from one form to the next?

Wahoo! Thanks mike... I was wondering why that wasn't working.

ramani... that didn't work.. the records are still there. don't you have to specify the table name you are deleting the records from? also, is their a better way to do this?

what is the easiest way to delete all the records in a table? I'm thinking of just writing a sql statement in the command window. What would it look like? delete * from [tablename]????

nah... i don't think so, man. Thanks for your help anyways.

Yeah, I could do that, but then my tabs won't work. Is there a way to do both?

I know this question was asked already, but I can't find the thread anymore. When the program is is running, and someones keeps hitting backspace, it jumps to the previous textbox. How did you guys fix that?

I think I got it working now. My sql statements were a little messed up. I'll post again if I have anymore problems.

Ok... I made the database for my program. But when I try and add sql statements in my code, I keep getting syntax errors. I'm a little confused here. Do I have to add code to communicate with the database, or does it do that automatically because it's all in the project manager section?

Thanks guys. That cleared some things up.

Hi all... I'm new with vfp. I'ved worked with vb and java but I'm pretty lost when it comes to this language. Anywho, my question is this. How do you assign variable to a label class or a text class?? I'ved tried using txt1 = ln1, but that doesn't work (data type mismatch.) Another quick...