Search results for query: *

I hate to start up this thread again, but if anyone uses SAP, they'll know of its horrible translations. :-) The one that comes to mind is the german word for "contractor" got translated as "Insignificant employee"... I always tease my contractor friends at work when it comes to our safety...

thanks....i feel really stupid now...actually i was coming back to write a reply like that. It had just occurred to me! i wanted Y=1 so that i could do sum(Flag*qty), but then i realized that i would select the "Y"'s only anyway. thanks for your help, and please don't laugh :)

How would i select one value based on another? the table stores its value as "Y" or "N", but i want 1 or 0. if they were numbers, i could perform the operation much more easily. if anyone can suggest a better way to do this operation, i'd love to hear it because i'm running out of ideas here...

Cjac, thanks for the info! i had never even thought of that. So you're saying that the current db i have now with the linked tables will suffice? the only thing i'm worried about is now it should run even slower, as i'm using OLEDB to connect to access, and then through the already slow...

thank you for your replies. Artichoke, Does looping through the recordset significantly increase query time? The problem is that the query (as it is now) takes two hours. Part of this is because it has to go over a T1 line. The other part is that the DBA doesn't re-index the table very...

I need to use two recordsets from different sources. specifically, I query our main DB (ODBC) to get updated price information. In an access DB, i have some extended fields for the products, like length, width, and height. I need to have it update the pricing in the existing table and also...

oh i know....that was just an old bit of code....i changed it to first look for the open connection, and use it if it is open. i tried to do: sConn = "DSN=PPC;USER=user;PASSWORD=pw;" and also adding those lines to the file DSN (using notepad) neither way worked.

...Exit Function End Function here is a sample sub: Private Sub Command2_Click() 'test procedure Call DbOpenGAP With GAPrs .Source = "SELECT * FROM DFBILL WHERE ProdCat=711" Debug.Print .Source Set .ActiveConnection = GAPcn .CursorLocation = adUseClient .Open , , adOpenDynamic...

I can't use a connection string b/c it never would work....however this is from the file DSN that i use. [ODBC] DRIVER=Transoft ODBC Driver Description=wtrans Timeout=35 Port=7000 Server=ppwsco TSDSN=wtrans I even tried adding lines for the username and password, but that didn't work. I can...

First, thank you for your replies. Secondly, the database is called TechGAP, which i believe now belongs to integrasoft. The ODBC driver is the Transoft U/SQL driver, v3.10.0.400. koala15, thank you for the article...i will try it this morning, but from an initial read, it seems to be what i...

I'm writing a program that ultimately will dump data into our old DB server (COBOL) using a 3rd-party ODBC driver. I have absolutely no problem with the SQL statements, but the server requires that you log on EVERY time. it pops up a window titled "GRANT and REVOKE Security," and there is no...

thanks...you're right...access doesn't like having a field called "Date" i thought that the Database Password=" part was for a password...i haven't protected it yet...it's still in development thanks again! lk

hi, i'm having a problem with this code objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.Mappath("loginlog.mdb") & "; Jet OLEDB:Database Password=" sqlString = "INSERT INTO Distributor (Company, Date) VALUES ( '" & login & "'...

I know this sounds crazy, but I made it auto select the first row after it loads the data and this seems to have fixedd it. If anyone has an explanation, I'd be glad to hear it. thanks, lk

I am using VB6 SP5, but i'm relying on the recordset to set the first row. when you say "set the first row", do you mean set the columns to the number of fields in the recordset? thanks, lk

Ok, i've looked all over and now i can't figure this out. I use a HFlexgrid to display records from a access database. first i tried using an ADODB recordset and setting the felxgrid's datasource to the recordset. then i tried using an ADODC control as well. the result is the same. if the...

Right now i use a query string to send the variables. (zipcode and an origin zip code) The ASP page reads these, writes them to session variables and then goes to another stage of the web program. the program needs some more info to determine a freight price, like which type of truck to use...

ok....maybe what i meant wasn't SOAP :) the examples that i saw used a SOAP envelope with XML, and made a reference to the MS XML library. i guess one question would be, can i make my program wait for a response from the server?

I'm trying to integrate a web-based progrram into a VB6 program. basically, the VB program sends a ZIP code to my web program, and then the user selects some variables, and the web program outputs up to three options. The user then selects one and i need that data (a company and a price) to...

I have a new MSI (VIA KT266A Chipset) with a VIA onboard LAN. the Link and activity lights come on while the computer is booting, but after the windows 98 splash screen appears, they go off and the network will not work. Windows still recognizes that the card is present in the system, but the...