Search:

Type: Posts; User: Bob Worsley

Page 1 of 80 1 2 3 4

Search: Search took 0.25 seconds.

  1. Replies
    8
    Views
    89

    Re: OT: SQL syntax (IIF function)

    Hi Sture,
    wouldn't a simple join of Customer and Order on CustNo be the same thing other than you would also get all Order columns too if actually using the *? Maybe you have a reason to use the...
  2. Replies
    2
    Views
    53

    Re: Extended ASCII characters

    Where I've run into this is simply attempting to read our current database using a 64-bit DF-20 copy of the same program we use in 19.1. We didn't know that these characters were in the database and...
  3. Replies
    8
    Views
    89

    Re: OT: SQL syntax (IIF function)

    Hi Sture,
    I've never used the IIF function though I know it's out there. I generally use a case statement for that kind of thing even for True/False even if the IIF might be a little simpler.
    ...
  4. Replies
    2
    Views
    53

    Extended ASCII characters

    Postgres database, DF-19.1, Mertech driver

    We've been finding that the users have been copying text from emails into a DF view which would normally be ok except that in some cases we're getting...
  5. Replies
    2
    Views
    110

    Re: DF-20 ODBC Incorrect Data Type

    I havenít tried the new beta, I am currently testing with this version. Is the new CK for that beta backward compatible to 20.0?
  6. Replies
    7
    Views
    170

    Re: Win32fh vdeletefile error

    Thanks Wil, youíre the best
  7. Replies
    7
    Views
    170

    Re: Win32fh vdeletefile error

    Hi Wil,
    yes, that's the zip & version I used. No worries about asking, I can be a bit vague with my descriptions at times
    It's hitting the intended code in my DF-20 library - the "latest" version...
  8. Replies
    7
    Views
    170

    Win32fh vdeletefile error

    DF-20 64-bit

    I've been testing a program in DF-20 64-bit and one function that's throwing an error is vDeleteFile in the latest vWin32h library. Using the normal syntax it throws an error 87 for...
  9. Replies
    2
    Views
    110

    DF-20 ODBC Incorrect Data Type

    Onto the next problem. Postgres with ODBC driver DF-20, 64-bit.

    Look at the two attached images. The first is DF-19, the two indicated columns are citext and are shown as ASCII data type which...
  10. Replies
    10
    Views
    205

    Re: DF-20 system table errors

    Having said that the addition of the "index" fixed the problem is only half the story. If the original .int file is used, as created by the wizard, you can open the table in dbExplor but the table...
  11. Replies
    10
    Views
    205

    Re: DF-20 system table errors

    Adding a table constraint for recnum as unique fixed the problem. Also, the original .int file worked, I didn't need to use your suggestion or is it better that I do?
  12. Replies
    10
    Views
    205

    Re: DF-20 system table errors

    There's no index. There's no index on the 19.1 version either but that's a different driver. I'll give it a try
  13. Replies
    10
    Views
    205

    Re: DF-20 system table errors

    Here ya go...
  14. Replies
    10
    Views
    205

    Re: DF-20 system table errors

    I still get the 12 errors but now I'm seeing data after clicking through them. Progress!

    Created by one of the wizards, I think the Connect Wizard if I remember correctly
  15. Replies
    10
    Views
    205

    Re: DF-20 system table errors

    DRIVER_NAME ODBC_DRV
    SERVER_NAME DFCONNID=ConnODBCID
    DATABASE_NAME wwsys
    SCHEMA_NAME rms4


    RECNUM_TABLE YES
    PRIMARY_INDEX 0
    TABLE_CHARACTER_FORMAT ANSI
    USE_DUMMY_ZERO_DATE YES
  16. Replies
    10
    Views
    205

    DF-20 system table errors

    I'm attempting to connect to a Postgres database with the ODBC driver using a DF-20 program compiled in 64-bit. One problem I've found that all system tables throw the following errors when opened...
  17. Replies
    7
    Views
    257

    Re: Won't start

    Good call Vincent, that was it. I bet that will bite others, any way to provide an error for that condition? Or is it at too low a level? Thanks!
  18. Replies
    7
    Views
    257

    Re: Won't start

    Hi Dennis,
    Good thought but there's nothing that shows up when I try to run the program
  19. Replies
    7
    Views
    257

    Won't start

    I compiled an application in DF-20, 64-Bit that runs fine in 32-bit and it will not start. In the debugger it just shows Loading and then Exiting with no errors and nothing on the screen. Same...
  20. Replies
    8
    Views
    206

    Re: Database conversion

    After spending a little time looking at these tables I'm thinking this is a data issue. Out of 88 total tables there are relatively few with this error. Most of these tables have note fields and...
  21. Replies
    8
    Views
    206

    Re: Database conversion

    I got some of my .int files created but have run into a different problem. Some of the tables open normally with dbExplor but some of them open with the following error. Is there some kind of...
  22. Replies
    8
    Views
    206

    Re: Database conversion

    Stephen,
    I understand the intent of the various choices as you've outlined them. What I was thinking is if I removed the database identification from Filelist that the tables would look like they...
  23. Replies
    8
    Views
    206

    Re: Database conversion

    Hi Mike,
    That's the choice I was originally asking about - tried it but the wizard won't allow selecting most of the tables.
  24. Replies
    8
    Views
    206

    Re: Database conversion

    Yes, the repair wizard. It says "can be used to connect to SQL tables for the first time or to resynchronize to SQL tables that have already been connected" so I thought that would be a way to...
  25. Replies
    8
    Views
    206

    Database conversion

    I've been trying to convert a workspace to ODBC using the database repair wizard. My goal here is to create all of the .int files but when it comes to selecting the files to create the .int files...
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4