Search results

  1. B

    VB.NET ODBC and Locking

    You can set that directly in the odbc driver settings. Although I am after the same answer to that question, so if anyone knows..... :)
  2. B

    Read Uncommitted

    I've tried this in SQL using Progress 9.1D and I get fed a syntax error, is it possible to set the isolation level in pure sql or do I _have_ to set it in jdbc driver settings? Cheers Tom
  3. B

    Progress > SQL Server 2005?

    Thats the best piece of advice I've had in a long time! just dropped my query down from 300 seconds to 25. Great Stuff
  4. B

    Progress and its annoying Parser

    Turns out that if I remove all aliases and define full table paths in the grouping, it seems to work... Eh?
  5. B

    Progress and its annoying Parser

    SELECT PUB.D2_SORD_DEL_HEAD.sdh_deliver_num , PUB.D2_SORD_DEL_HEAD.sdh_deliver_name , PUB.D2_SORD_DEL_HEAD.sdh_deliver_addr1 , PUB.D2_SORD_DEL_LINE.sdl_deliver_wght , PUB.D2_SORD_DEL_LINE.sdl_deliver_vol , PUB.D2_SORD_DEL_HEAD.sdh_deliver_date , PUB.D2_SORD_DEL_LINE.soh_num ...
  6. B

    Progress 9.1D SQL If Statement

    Never mind, I found out it likes CASE statements
  7. B

    Progress 9.1D SQL If Statement

    May be a dumb question.. If(PUB.D2_SORD_DEL_HEAD.sdh_del_method='001','D','C') AS ORDERTYPE if that sorta thing right for an IF statement or have I got it wrong? Cause no matter what I try I get a syntax error. Cheers Tom
  8. B

    Read Uncommitted

    Yeah, but if you're not using ODBC thats out the window :)
  9. B

    Read Uncommitted

    Hi Guys, Im not using SQL Explorer(JDBC) but Kettle when setting up a connection or running a query I can't for the life of me work out how to set the transaction read uncommitted. I've tried SET TRANSACTION ISOLATION LEVEL UNCOMMITTED READ and the @TRANSACTIONISOLATION 0 but neither have...
  10. B

    Triggers / Data Dictionary / Copy fields

    Sorry by forget it I mean it not going to update the new record if the old one is edited? This parent table is deleted at the end of the day and obviously I don't want all the old new records disappearing, I'm just trying to keep a log of every product code entered into this table. Anyway I've...
  11. B

    Triggers / Data Dictionary / Copy fields

    Thanks for the reply, I've actually managed to come up with a quick bit of code but I'm still struggling. I want my trigger to copy the data then forget about the new one so when the old records are deleted (the following night)it will leave the new copies(I'm not sure if I understand you...
  12. B

    Triggers / Data Dictionary / Copy fields

    Hi Guys, I have very little knowledge of 4GL(Progress 9.1D) and usually use SQL to rip the data I need from the tables, but I need to implement a trigger on a table that copies a few fields from one table to another whenever a record is inserted and I was hoping someone could help. Ive created...
  13. B

    Symbols in column names

    Cheers Casper Its one of my small SQL bug bears, not aimed at Progress but they all have to be just slightly different syntactically dont they :) Tom
  14. B

    Symbols in column names

    Whoever designed this database thought it'd be a great idea to put a minus sign in the doc-id column header, so in a sql query how do I ask it to look at pub.blah.doc-id without it giving me a syntax error? Cheers Tom
  15. B

    Progress JDBC - Pentaho Kettle

    Right I've been playing around with my various 9.1C and 9.1D database's with the ODBC drivers on my XP box, they work fine, but as I've read in lots of places the jdbc drivers performance is better so I thought I'd give them a shot as my ETL program is java based anyway. So I followed a guide...
  16. B

    ODBC and Function Sequence Error

    Thanks for the reply, I have noticed that 9.1C is a little flaky when it comes to SQL. Whilst we're talking error codes can anyone tell me what MM- Bad Swap Block means and how it can be avoided? Cheers Tom
  17. B

    ODBC and Function Sequence Error

    Hi Guys, I have been playing around with SQL on our Progress 9.1C installation at work and I was wondering if anyone can enlighten me as to what a 'Function Sequence Error' is its an intermittent fault that happens every now and again but causes our connection to bomb so I need to resolve it...
  18. B

    ODBC returning different totals to 4GL

    Solved it, removed the Having and replaced it with a Where clause and it stopped skipping the dupes. doh. Cheers Tom
  19. B

    ODBC returning different totals to 4GL

    This morning I re ran the query on Access just a basic select all within the month and of 002 status and it returned them, I worked out which transactions were missing and re-ran the query and they appeared and it seemed to drop others. So I switched on ODBC logging, which reported nothing but...
  20. B

    ODBC returning different totals to 4GL

    Well as I say the progress code is nothing to do with me, its the guy sat opposite at work, I just leave him to it. But SQL wise the data should be grouped by BranchCode and so as we're summing the whole bunch of data for that branch they should total to the same amount(I think), regardless of...
Top