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!

  • Congratulations TouchToneTommy 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. memevertical2

    Database on Server, how can I access it?

    Oh, you mean like if it was shared on a local network? Thanks.
  2. memevertical2

    Database on Server, how can I access it?

    Hi everyone. I made an app that uses a MDB (access) database. But now, my boss wants to have that same app on our second office (which is on a different location), and be able to access the same database. He wants both offices reading and writing to that database. How can I do this? Can I just...
  3. memevertical2

    Can someone point me in the right direction?

    Thanks, I believe there will no more than 5 users. The application will handle the basic information from the Database, it will load info at startup, and the user will input info, retrieve info, print reports.....the basic stuff..... What I would like to know is how to install the SQL Server...
  4. memevertical2

    Can someone point me in the right direction?

    Oh, well, I just assumed SQL Server handles multi-user better.....but if I can do it with MDB better yet, so on each computer a just point to the network address where the database is??? or how can I do it?
  5. memevertical2

    Can someone point me in the right direction?

    Lately I've been working on applications that read a MDB database.....and the language used inside Delphi is SQL, with the ADOquery..... But now I need to develop a similar application, but in multiple computer that all read from the same database.....I guess for this I need to use a SQL...
  6. memevertical2

    How do they do that!!!????

    Thanks guys....I'll check it out....
  7. memevertical2

    How do they do that!!!????

    Hi, there is a software that displays items on a Grid. The first field is a picture, and there is another field that is the picture's URL, and when I enter the URL for everything, the images start to appear one by one....and the next time I open the app, they start to appear 1 by 1 again. I...
  8. memevertical2

    ADOQuery Giving me trouble again....

    Ok cool, it works!!! :) Thanks a lot!!!....
  9. memevertical2

    ADOQuery Giving me trouble again....

    So, do you think its a good idea to include [] on all fields in case the user creates a column with other reserved word?
  10. memevertical2

    ADOQuery Giving me trouble again....

    Hi, Size is a normal, text column.... I tried a single insert for SIZE and it gives error, if I rename the column to SIZES it does work. I'll try to enter value for all fields so that I don't have to name each one..... I'll let you know how it goes.... Thanks again...
  11. memevertical2

    ADOQuery Giving me trouble again....

    How can I know the DBMS I'm using? and how can I find out the syntax to use a reserved word in a field? Thanks.
  12. memevertical2

    ADOQuery Giving me trouble again....

    Ok, let me be more clear. I have no control over what fields are created, and the names the user assigns to it. So, in an example table, there is a field called SIZE....it crashes there, so I assume its a reserved word, so I want to insert values not referring to the name of the field, but with...
  13. memevertical2

    ADOQuery Giving me trouble again....

    Thanks. Well its not really that dangerous, because I first run through all the names of the fields, and copy their index numbers, and then, with those numbers I intend to do the insert. But how do I make the "INSERT INTO" with that function you said? I've never used any of those..... Thanks a...
  14. memevertical2

    ADOQuery Giving me trouble again....

    Ok, I found info on it and got it to work.... THANkS!!! Now, my question would be, can I add a value to field, but instead of refering to the field by name, just refer to the field number..????
  15. memevertical2

    ADOQuery Giving me trouble again....

    Thanks for writing. Can you tell me how to do a normal INSERT using the PARAMETERS property???? Thanks a lot.....
  16. memevertical2

    ADOQuery Giving me trouble again....

    Well, the actual SQL.Text reflects like this: Values('Piece 14" 7x10 mm','1/1/2008 12:00:00 PM') And like is said, when I INSERT just the title, it works, and if I INSERT just the date, it works....but together they crash.....dont know why.....
  17. memevertical2

    ADOQuery Giving me trouble again....

    OK, FINAL UPDATE, I promise.......So I figured out that when I INSERT just a weird Title its all good, if I Insert just a Date its all Good....but when I INSERT both there's the problem....here's an example of when it gives an error: ADOQuery2.SQl.Add('INSERT INTO Listings (Title,SaleDate)')...
  18. memevertical2

    ADOQuery Giving me trouble again....

    Man, this is confusing.....ok, so, the FIELD called TITLE, some times has weird characters, but, If I make an insert of just the title, it doesn't give trouble, but if I insert the title and all the rest 50 fields, it does give trouble....and if I insert ALL fields, without that Title, it does...
  19. memevertical2

    ADOQuery Giving me trouble again....

    Ok, here's an update. I see that the 2 fields giving me trouble are DATE fields. Now here the part that confuses me: I tried running the SQL Text entered directly, and using the procedure I made. On both cases I used a SHOWMESSAGE just to see the value of the SQL.Text before it executes it...
  20. memevertical2

    ADOQuery Giving me trouble again....

    Hi, thanks for writing. I'm not sure what you mean by DBMS, but I'm using a MDB database file, and using ADO components. I tried re-naming the field, and It did work. But I know face a different problem. The only way I know how to insert a record is with that command, and I have a procedure...

Part and Inventory Search

Back
Top