jfalvarez

Hello i2dx.

In these moments I am trying to create the installer of my database application, but when I execute it appears me the message of error "the database file does not exist!" does error number 5012, that way should carry out my installer and where I should locate the file of my database?

Thank you.

Thank you i2dx this is exactly what needed and in any thing that I can help you, don't doubt to request it to me.

You have for always a Colombian grateful friend.

Man look

If he finds the code that I attach a copy of a task I would like him to tell it to me in my face. I have already had experience during all my career with labview, also to make clarity I am no longer any student, for their information I am ELECTRONIC ENGINEER not meaning that to be professional I have to be an erudite in the database topic, for the opposite it is first experience that I have with them and thanks to i2dx I have had a great advance in the knowledge of databases.

I suggest to you and I request the favor to you that before making asseverations of this type; it verifies in decent way who is who.

Suddenly in a future I can serve you in something that you need and you that I will make it with a lot of pleasure.

And if for something I have been distinguished in the life it is to be right in my professional things, and when I have to look for help like it is the case I make it without any fear.

Thank you.

Hi i2dx.

I have labview 8.0 and i can't open the file that you send me, can you change the version of this file?

Thanks.

Man look

If he finds the code that I attach a copy of a task I would like him to tell it to me in my face. I have already had experience during all my career with labview, also to make clarity I am no longer any student, for their information I am ELECTRONIC ENGINEER not meaning that to be professional I have to be an erudite in the database topic, for the opposite it is first experience that I have with them and thanks to i2dx I have had a great advance in the knowledge of databases.

I suggest to you and I request the favor to you that before making asseverations of this type; it verifies in decent way who is who.

Suddenly in a future I can serve you in something that you need and you that I will make it with a lot of pleasure.

And if for something I have been distinguished in the life it is to be right in my professional things, and when I have to look for help like it is the case I make it without any fear.

Thank you.

Hi i2dx, I can't open it because i have Labview 8.0, can you help me change the version of the archive?

Thanks.

Then because you don't help me instead of criticizing what I need.

thank you :question: :question: :question:

Man look

If he finds the code that I attach a copy of a task I would like him to tell it to me in my face. I have already had experience during all my career with labview, also to make clarity I am no longer any student, for their information I am ELECTRONIC ENGINEER not meaning that to be professional I have to be an erudite in the database topic, for the opposite it is first experience that I have with them and thanks to i2dx I have had a great advance in the knowledge of databases.

I suggest to you and I request the favor to you that before making asseverations of this type; it verifies in decent way who is who.

Suddenly in a future I can serve you in something that you need and you that I will make it with a lot of pleasure.

And if for something I have been distinguished in the life it is to be right in my professional things, and when I have to look for help like it is the case I make it without any fear.

Thank you.

Download File:post-6467-1160971350.vi

Forgive me clerf, but this it is a direct question for i2dx, I believe that be clear.

Then because you don't help me instead of criticizing what I need.

thank you :question: :question: :question:

Don't worry i2dx.

I don't want that you make me the code, the only thing that I request you is an example.

For example in to example ado-bsp_2 you use a database and (adobsp.mdb) inside her you have a series of data, the only thing that I want to learn how to make is as to consult a column of a database from a contron string and to visualize the result of the consultation in an indicator string.

It would value your help a lot since it is of supreme importance for the finalization of my project, and I swear you that I don't bother you but with this topic.

And thank you for your previous help since turned on a very important light to advance the code that I am developing.

Forgive me clerf, but this it is a direct question for i2dx, I believe that be clear.

I did not want to blame you, and I apologize, if you understood my last post in that way. But fact is: it's almost impossible to support a database development through a forum - I can help with direct questions like "This SQL query gives me an error ..." but I can not help with database design and query design, because, I am not into your data, your code, etc

Don't worry i2dx.

I don't want that you make me the code, the only thing that I request you is an example.

For example in to example ado-bsp_2 you use a database and (adobsp.mdb) inside her you have a series of data, the only thing that I want to learn how to make is as to consult a column of a database from a contron string and to visualize the result of the consultation in an indicator string.

It would value your help a lot since it is of supreme importance for the finalization of my project, and I swear you that I don't bother you but with this topic.

And thank you for your previous help since turned on a very important light to advance the code that I am developing.

hmm, sorry, I have no idea what you mean, but generally I'd say: maybe you have to spend a few bucks and buy a SQL Book? Database Toolkits are allmost useless without some Knowledge of SQL.

cheers,

CB

Appreciated i2dx.

I know perfectly that I am beginning to know on databases, it is possible that I have abused of your knowledge, but if I had the opportunity to share my knowledge for a person that needs it with a lot of pleasure I would make it, as well as to you you are facilitated this topic to my they are facilitated others that would be you in a future.

I would like you to help me in what I need and maybe I could help you in electronics that is my specialty.

Hello i2dx.

Of my previous consultation I wanted to make some explanations that it is what I am needing.

I want to make kind of a consultation form where I can write in a string control a date inside a column of one of the table of my database and the program looks for that date and it shows it in a string indicator, for example a first name, a last name or a number of identification and when I make it it shows the results associated to this entered date.

Thanks.

Hi i2dx

How can I carry out a code where one can make a consultation of a database in LabView?

Thanks.

Hello i2dx.

I have a technical question and a doubt with your example ado-bsp_03.

The technical question consists in:

How can I carry out a code where one can make a consultation of a database in LabView?

The doubt that I have with your example ado-bsp_03 is that when I try to open it in labview, this requests me a libraries which are:

- ADOTool_Access_BinData Array to Hex String.vi

- ADOTool_Access_poly_1D SGL Array to HEX String.vi

- ADOTool_Access_HEX String to BinData Array.vi

- ADOTool_Access_HEX-String2 1D SGL Array.vi

Really, me not you if the libraries that I mention lack in your ADO-Tool and if it is could you publish this way them in the forum; or do these libraries make part of another tool?.

Already attempt both versions of your examples that you published opening up.

Thank you for your patience and I value your help a lot.

I2dx Thanks so much, your help is very important for me.

ok, I took a look:

You get the errors, because your SQL Statements are not correct. Because I don't know exactly, what you want to archieve, I'll explain it a little bit more genericaly:

Imagine you have 2 tables in your access database, the first table, "tbl_1" has 4 columns:

id_tbl1 --> AutoValue, PrimaryKey, increment

firstname --> text field, length 50 chars

lastname --> text field, length 50 chars

numvalue --> numerical value, long integer

the second table "tbl_2" has 5 columns:

id_tbl2 --> AutoValue, PrimaryKey, increment

fk_tbl1 --> Foreign Key to id_tbl1, numerical, long integer

nvalue1 --> numerical value, double

nvalue2 --> numerical value, double

nvalue3 --> numerical value, double

You want to insert one row in tbl_1 and

3 rows into tbl_2, which refer to the row you inserted in tbl_1 before

Your format strings, to format your SQL-Statements should look like:

INSERT INTO tbl_1 (firstname, lastname, numvalue) VALUES ('%s', '%s', %d)

connect that to the "ADOTool_Insert Data Get Identity.vi", which gives you back the value of id_tbl1 of the previous inserted row (it makes a Querie "SELECT @@identity" ...) at the DB AutoID output. Please note, that you have to put quotes >'< around string data!

e.g. if firstname = Lite, lastname = Miller and numvalue should be 15, your insert statement is:

INSERT INTO tbl_1 (firstname, lastname, numvalue) VALUES ('Lite', 'Miller', 15)

let's asume, that was the 154th row, you inserted in that table, thus the DB AutoID = 154 ...

Your second insert Statement should look like:

%.;INSERT INTO tbl_2 (fk_tbl1, nvalue1, nvalue2, nvalue3) VALUES (%d, %0.15e, %0.15e, %0.15e)

%.; is used to make sure that the dot is used as decimal point, not the comma ...

if your values are 16.7 , 745.3, 9523.742 --> your statement is:

INSERT INTO tbl_2 (fk_tbl1, nvalue1, nvalue2, nvalue3) VALUES (154, 1.670000000000000E+1, 7.453000000000000E+2, 9.523742000000000E+3)

Please notice that the "RowCount" MUST MATCH the "ValueCount"! --> that means

INSERT INTO table name

(Col1, Col2, Col3, Col4) <-- here you define, you want to insert into 4 columns

VALUES

(Val1, Val2, Val3, Val4) <-- therefore you have to provide EXCACTLY 4 values!

I hope that helps ...

cheers,

CB

Hello Id2k.

In your example ado-bsp_02 I try to make some modifications that were coupled with my current necessities

I don't really understand much of databases but I try to make the best thing possible with unfortunate been for that when I execute my application it leaves the error code -2147217900, I don't really know where is possibly my error in the code and in the database that I carry out.

I please request you help me since it is high-priority for my to conclude my project; for that only makes me lack to enter this code portion to conclude my program in LabView.

If you are so kind you correct me my errors and this way to be able to finish with my problems.

Many thank you.

Hello Id2x.

In your example ado-bsp_02 I try to make some modifications that were coupled with my current necessities

I don't really understand much of databases but I try to make the best thing possible with unfortunate been for that when I execute my application it leaves the error code -2147217900, I don't really know where is possibly my error in the code and in the database that I carry out.

I please request you help me since it is high-priority for my to conclude my project; for that only makes me lack to enter this code portion to conclude my program in LabView.

If you are so kind you correct me my errors and this way to be able to finish with my problems.

Many thank you.

Download File:post-6467-1160719717.zip

Download File:post-6467-1160720308.zip

Hi Id2x

At the moment I am making a small project connecting an optoelectronic device by means of the protocol rs232 in labview, which makes software is to capture different times in a numerical array, which I have not been able to do is to send this numerical array to a data base developed by means of MS Access. Can you help me with an example of this?

Thanks for your help.