Search results for query: *

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

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

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

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?

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

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

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

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

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

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

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.

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

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

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..????

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

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

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)')...

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

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

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