Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kermit01de

    gaps between item numbers

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

    gaps between item numbers

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

    gaps between item numbers

    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]...
  4. kermit01de

    WHERE datefield &gt; Yesterday() ???

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

    WHERE datefield &gt; Yesterday() ???

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

    Export &gt; 400000 records ?

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

    Export &gt; 400000 records ?

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

    assistance find dups - another issue

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

    POS Mapping Tool

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

    POS Mapping Tool

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

    POS Mapping Tool

    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...
  12. kermit01de

    POS Mapping Tool

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

    Error 812 when setting up integrity rule &quot;Firewall active&quot;

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

    When is data at risk of Restructure?

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

    How to code carriage return in a macro

    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 ... <<<<<
  16. kermit01de

    How to code carriage return in a macro

    Then try vbCr or vbLf instead One of them should do what you expect Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<
  17. kermit01de

    WINDOWS 98SE WANTS TO REINSTALL VIDEO DRIVER ON EVERY REBOOT

    Some years ago, I remember, I had a similar issue. Try the following: - Boot in safe mode - verify first, that SUPERVGA.DRV is the correct one, otherwise you may copy it from the W98 CD. - remove all graphics adapters from devicemanager - reboot ... Maybe that could help?! Kind regards Mirko...
  18. kermit01de

    How to code carriage return in a macro

    Try that ... Dim MyText As String MyHeaderText = "..........................." & vbCrLf & "Paul | new words for the week | Best-English.org | 1 of 1" etc. Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<
  19. kermit01de

    Error 812 when setting up integrity rule &quot;Firewall active&quot;

    Hi all, Szenario: SVR1 - W2K8R2, NPS, Routing&RAS --NPS Proxy redirecting to SVR2 SVR2 - W2K8R2, NPS CLI1 - Win7SP1, NAP Client enabled L2TP VPN works from client via SVR1 to SVR2 As soon as I implement a Windows Security rule ... integrityrule - networkrule on SVR2 saying "Client Firewall...
  20. kermit01de

    To Print Data Report in Network Printer

    I am just trying to help without any possibility to test myself at the moment. As you are a programmer, you may try another syntax for the printing - eg. printer.print Fullreport printer.enddoc Kind regards Mirko -------------------------------------- >>>>>> ... I am sure, some...

Part and Inventory Search

Back
Top