>I'm trying to pull data out of a free table with a sql statement that i copied from a view I made.
>When I run the view from the view designer it runs fine, but if i copy the sql statement then run it from my
>command button or the command window it wont pull the data out. I don't get any errors it just doesn't
>seem to find the data when i know its there. If I have the view designer open and run it there it works. Then
>if I copy the statement into the command window it will work, but after I close the view designer it stops working.
>
>here is a sample of what my select statement looks like
>
>select cash.cashadd, cash.cashdep, cash.cashop;
>from cash;
>where cdate = date()
>
>Thanks Kelly
I ran into something like this before when I found that I had another table in my path with the same name. I thought it was working on the one that was in the DBC but in reality it was working with a table that had no records in it that just happened to be in my path.
Check to see that you dont have a table called cash some where else open or in your path that it could be reading from. When the view is open it knows to use what is there, but it may not when it is closed.
Just my 2 cents
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope