Hi,
anyone have experience in new hybrid for mysql ce?
I have to connect OE 11.7 with MariaDB, somebody has had this experience? Suggestion or maybe some example?
many thanks
G.
Sorry Tom. Maybe I didn't express myself well. First of all my OE v. is 10.2b.
The code below works well for any table except 'user'.
I can only deduce that the problem is relative to the 'user' table. That's all. 'User' table exist in the access database. Infact the error displayed is...
no the error is different: SQL command not valid.
Sorry user without inside the quote. Select * from user running in the OE editor doesn't work while Select * from user-info works.
AS your suggestion Select * from pub.user from OE editor works, not for Cmd = NEW...
Tom,
if I change the name of the table, for example user_info, works properly. My problem is for the "user" table.
"user" is a special word for OE. I tried different solution without success.
Thx.
G.
HI to All,
thanks for your reply. Below you can see the code:
DEFINE TEMP-TABLE ttEmpl NO-UNDO
FIELD EmplID AS INTEGER FORMAT "zzzzzz"
FIELD EmplName AS CHARACTER
FIELD EmplLastName AS CHARACTER .
chrQuery = "(Select * FROM user)".
Conn = NEW...
Hi,
How I can solve this problem? USER is the name of a table in an access database. I need to inquiry it, but OE shows an error of syntax.
Select * FROM USER.
Many thanks.
G.
Hi,
My question is for to display data in existing query already opened.
I would like to have a difference sort by in the same browse.
Ex.
If I press Botton1 I have a query sort- by name. OPEN QUERY QC FOR EACH customer NO-LOCK BY name..
If I press Botton2 I have a query sort- by cust num...
Thanks for your reply.
I need only one table for time (customer in this example).
My problem also is how show the records extracted in a QUERY already defined in frame.
OPEN QUERY QC FOR EACH customer WHERE (result of "QS") NO-LOCK BY cust-num .
Is it possible?
Hi,
thanks for your reply. Let me explain better.
I have defined an OPEN QUERY (QC) for customer table with different sort-by in frame-a.
My problem is to show same records in the table considering the result of this research.
For example shows each records that contains not in one field but...
Hi to All,
question I think simple for you.
I have a temp-table that contains same records for customer table.
I have a query (QC) that shows customer records.
In the QC query I need to show only customer records inside the temp-table.
For example:
for each temp-table where .....
open query...
Hi to all,
I need for your help for to read the following tag using sax-reader. I didn't find in any example.
<tel:extra type="Fax">+41313052181</tel:extra>
<tel:extra type="email">info@veranda-bern.ch*</tel:extra>
Many thanks.
A.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.