Recent content by kermit01de

Unfortunately this does not work: Select t.[No_]+1 as LueckeVon, (Select MIN(CAST([No_] as int))-1 From [BODAN600].[dbo].[BODAN Gh_ für Naturkost GmbH$Item] Where CAST([No_] as int)>CAST([No_]as int)) as LueckeBis From [BODAN600].[dbo].[BODAN Gh_ für Naturkost GmbH$Item] t Where...

Thank you Borislav, I already checked it, but as I am no SQL-Programmer - how to integrate in the existing script? I tried several things - without success. Any hint? Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

Hi there, we have an SQLtable "item" that contains a full range of items. We usually assign 6-digit-numbers as [No_]. I already have a script, that finds free numbers: Select t.[No_]+1 as LueckeVon, (Select MIN(CAST([No_] as int))-1 From [BODAN600].[dbo].[BODAN Gh_ für Naturkost GmbH$Item]...

Sorry, should be "Now()" But anyway - I just remembered, I did an export for Sybase SQLAnywhere years ago with VB6 - so I looked up the sourcecode and decided to do it with VB6. Works like a charm ... So this case may be closed. Kind regards Mirko --------------------------------------...

This is about SQL Anywhere 11 - with Visual Studio 2008 - via ODBC I try to create a query with filter to a datefield (LAST_CHANGED) > Yesterday. As from MSSQL I know "Today()-1" --- this does not work here. I also tried "> Dateadd (day, -1, Today())" - Invalid expression Does anybody have a...

Thanks Andy, that works perfectly. Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

Linked SQL-table qry: SELECT [dbo_GmbH$Sales Shipment Line].[Order Picker], [dbo_GmbH$Sales Shipment Line].Quantity, [dbo_GmbH$Sales Shipment Line].[Gross Weight], [dbo_GmbH$Sales Shipment Line].[Net Weight] INTO Kommi_1 FROM [dbo_GmbH$Sales Shipment Line] WHERE ((([dbo_GmbH$Sales Shipment...

For this example: Table SalesLine Field [orderno.] Field [Debitor] Field [item] orderno. - Debitor - item 10001 12345 1010101 10001 12345 1122334 10001 12345 1111111 10002 12222 1010101 10002 12222 1122222 10002 13344 1231231...

http://www.dascus.de/cso Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

CSO is available in english at dascus in Germany. Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

Ok, so I suggest to build a collecting database to import all relevant data from the different POS transaction databases / structures and then use the collected data to display reports, store-comparisons, whatever the customer wants. In fact you have to think about the central database...

I am not really sure, what you want to ask. - cutom reporting tools - interface to accounting software - auditing tools ? Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

Funny enough - I got it - as you all know about this and I think were ROTFL ... I do not comment anything. Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

Hi Stanley, Just about restructuring a table - you have to care for references in queries etc. 1. no 2. as you mentioned ... 3. yes ... generally eg. if you change date into text, you may not loose data, but it will be another format displayed. If you change length of a text field from 255 to...

Hmmm, what exactly do you expect as result? For what should it be? - Just for me to understand better. Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<