I need help forming an SQL statement. Any help will be greatly appreciated.
I have a table:
User    Type    Amount
101     AAA     150

After I execute a query an exit out, I can not reopen the query table to its original form, How do I save a query as a table for further use
La

Been fussing with this a while and am stuck  Could really use code sample.
I have a Unix time value of 1081954800 which actually translates to Wed, 14
Apr 2004 15:00:00 UTC.
Using Excel I can get it to convert by this formula: =Value/86400+"1/1/70"

I'm using a remote view for a parameter query which seems OK - until the data on the SQL Server table is updated. It seems as if the VFP remote view is cached and will not display the updated data. This is the case even if I close the application and restart it
The same view ...

I have created a View in Form Code Init Event
OPEN DATABASE C:\ABCdata\ABCdata.DB
CREATE    VIEW v_Clients AS   
SELECT    ClientID, Name   

I am getting an error when trying to update or insert a record with a memo
field where the memo field has formating chr such as <CR><LF>.  How can I
fix this?

I am having trouble with the syntax using SQLEXEC() as it relates to outer joins
I have two tables, pr_calc & pr_calc_earn. I want all fields in pr_calc_earn if the employe
exists in pr_calc
This is my code that gives me a syntax error

I have a vfp 6.0 project connected to MS sql 2000.  I can browse the
database correctly.  But when I issue the command "INSERT INTO XXX
(fieldname) values (values)", browse again the data is correct.
But it is not updated, when "close data all" and brow again, the new

I have inherited an existing FoxPro application using free tables, and have
been tasked with providing a data synching solution between 2 application
installations.  I am not one to recreate the wheel.  Has anyone seen a
product that I can use to accomplish this task?  The key is ...

I want to know if it is possible to do the following
1.- I want to make a View in Code, not in View Designer; for example, on a Form Init Event and pass some values via "?"variables
2.- After making a view, populate a grid with rows retrieved from that view
3.- Go to other place on ...

Is there a way to use something like IIF in a select statment to be used in SQLEXEC (SQL Server)
I want to convert something like IIF(table.field LIKE '', '9999', table.field) AS newfiel
Thanks

I am trying a SELECT statement in which one of the fields is a COUNT of records and I want to use this count in calculating other fields. When I try this in one SELECT statement I get an error "variable is not found". If I do the COUNT function and store the results in a view, ...

I'm running VFP 5.0 and want to do something unusual with my VFP tables. I
want to sum the number of records in table 1 (log_history) for today's date,
grouped by recipe_sn (ie: recipe serial number), and display it alongside
data from table 2 (log_list). Here's what the tables look ...

Greetings All,
This idea has been presented to me and I would like your option of it:
Instead of the traditional master and details table design where you would
have 2 files(master.dbf and details.dbf) and the details table is related on

I have to do a project for school and in it is a bit of SQL. I have to
write data from TableB into TableA. Since I don't know so much of it, I
thought I'd ask some help on a newsgroup.
The problem is that I have a TableA. In it is a field which needs to be