Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: CF
  Where is CF?
 Colmar
 Pennsylvania - Poland
 CF
 To: yoda
  Where is yoda?
 Mytown
 Alaska - United States
 yoda
 Tags
Subject: RE: SQL problem
Thread ID: 9901 Message ID: 34483 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, December 15, 2003 9:12:32 PM         
   


> OK, I've tried all of my database books and the MSDN and I can't figure this one out.
> I want to update my 'Clients' table with the following code:
>
>
> OPEN DATABASE DATABASE.DBC
> USE CLIENTS ALIAS CLIENTS
> 
> UPDATE CLIENTS; 
> SET PAYMENT_METHOD = THIS.PARENT.COMBO1.TEXT;
> 	WHERE SOCIALSEC = SOCIALSEC1.TEXT;
> 

>
> It gives me: 'ALIAS Combo1 not found'
>
> It pains me to ask for help on this one, but I can't beat it out of my books.
> Thanks.
>
> Also, does anyone know of some other sites that have SQL tips or examples?
>
>

Instead of comboBox.TEXT try comboBox.Value. In addition make sure you Alltrim and Pad you values to get the correct formatting

Regards

ENTIRE THREAD

SQL problem Posted by yoda @ 4/16/2002 6:10:51 AM
Try Replace command Posted by Ken Blum @ 4/16/2002 2:10:15 PM
RE: Try Replace command Posted by CJ moore @ 4/16/2002 2:25:49 PM
Maybe dependant on type of data in ComboBox??? Posted by Ken Blum @ 4/16/2002 2:32:50 PM
RE: SQL problem Posted by bleech67 toms @ 12/15/2003 9:12:32 PM