Recent content by gasomma

  1. gasomma

    New Hybrid Support For Mysql Ce, Mariadb, etc.

    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.
  2. gasomma

    SQL

    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...
  3. gasomma

    SQL

    I'm using another way now. Connect Access DB with ODBC driver and I can inquiry the table. many thanks. G.
  4. gasomma

    SQL

    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...
  5. gasomma

    SQL

    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.
  6. gasomma

    SQL

    is in Italian. syntax error in the query. incomplete query proposition Thx.
  7. gasomma

    SQL

    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...
  8. gasomma

    SQL

    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.
  9. gasomma

    Query

    Thanks a lot Tom. I will try,
  10. gasomma

    Query

    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...
  11. gasomma

    Query

    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?
  12. gasomma

    Query

    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...
  13. gasomma

    Query

    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...
  14. gasomma

    sax-reader OE 11.7

    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.
  15. gasomma

    Question OE .NET

    Thanks for your email. Account is a table as customer or vat. I would like to ask you if there is another way for connecting OE to sage. Thx. A.
Top