Search results

  1. H

    Help with SQL statement

    I bet we don't have it ... I know we are running a very old verison of MFG ... I guess back to having them dump out to csv and me picking it up from there. thanks for all your help, I least know this isn't possible currently
  2. H

    Help with SQL statement

    thanks again ... I'll try it out ::edit:: after talking to our progress programmer she can't find on the progress side where this is set, this is what she said. "can you find out exactly where this is set....I looked at the table definitions and do not see anything related to sql field...
  3. H

    Help with SQL statement

    I talked to one of our progress programmers and she is wondering if that needs to be set when the table is built or can it be set for an existing table without damaging the data? We are running progress v8.3c Thanks for all the help so far :)
  4. H

    Help with SQL statement

    this works in Progress select usrw_charfld[11] format "x(20)" from usrw_wkfl I just need the sql version .. the problem is, the field usrw_charfld[11] is defined as 8 characters, but we store 20 in it (I come from the SQL world, so I'm not sure exactly the terminology of being able to do that)...
  5. H

    Help with SQL statement

    I am trying to use SQL Server 2000 to pull from Progress using OpenLink Lite 8.3e .. the query I am trying to run is select usrw_charfld[11] format x(20) from usrw_wkfl i can run with no problems so it is a syntax issue select usrw_charfld[11] from usrw_wkfl the error I recieve is...
  6. H

    SQL Server DTS with format "x(32)"

    Sorry if this is in the wrong forum. I am trying to use OpenLink Lite for Progress 8.3e (Large Client) to pull our qad databases into sql server. I am having a problem pulling the usrw_wklf table. SQL Server sees all the user defined fields being 8 characters long, when I know they are not...
Back
Top