Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: incubeware
- Order by date
-
SELECT within SELECT Statement. Question
I Have done thay same thing as your example... in the following link i send you the images of what i have. http://incubeware.com/pervasive.html I'm lost with this error.. Or.. if you know a different way of doing this same thing.. Thanks in advance.. Carlos- incubeware
- Post #7
- Forum: Pervasive: Pervasive.SQL
-
SELECT within SELECT Statement. Question
Hi , Did the test, and have the folowing error. ODBC Error: SQLSTATE=37000, Native Error code=0 Syntax Error: SELECT COMP_REPORT_NAME , (SELECT <<??>> COMP_KEY FROM COMPFILE WHERE COMP_KEY = '1') FROM COMPFILE The Query is: SELECT COMP_REPORT_NAME , (SELECT COMP_KEY FROM COMPFILE WHERE...- incubeware
- Post #5
- Forum: Pervasive: Pervasive.SQL
-
SELECT within SELECT Statement. Question
What we have is... Pervasive.SQL 2000i And I open the Pervasive.SQL Control Center and open a query window over my selected database and then when i try to execute the statement i get an ODBC Syntax Error, at this moment I don't have access to the system... but do you think is possible to do...- incubeware
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
SELECT within SELECT Statement. Question
I'm looking for a way of doing something like this. Getting a very specific field from a different SQL Statement. I know in SQL Server and INFORMIX is posible to do this... but just can't find the way to do it in Pervasive. (new to the engine). SELECT Name, (SELECT max(InvoiceDate) FROM...- incubeware
- Thread
- Replies: 7
- Forum: Pervasive: Pervasive.SQL
