topic Re: checking the matching text in the database in LabVIEW

checking the matching text in the database

jeyanthi — Tue, 20 May 2008 02:29:29 GMT

hi need help..

I have stnid=SED001,SED002,...

sometimes let say there is no stnid it must store as SED9999/SED9998/...

its like this if true i pass the stnid to the database.

if false i must pass SED9999, if the database already have SED9999 it should store SED9999-1,...and so on

or i can use this

let say the stnid is false ..i create a vi and ask the user to insert a stnid...and check the database the number is already stored or not.

which one is better and how to that?

plz help

Re: checking the matching text in the database

MikeS81 — Tue, 20 May 2008 05:06:52 GMT

Hi jeyanthi,
i think the solution depend on what you want to do. Is it an automatic process where you have less as possible user interactions, then i would prefer the first solution. If it is important that stnid correct, nobody has to change it later, then i would prefer the second solution.
Can you explain more about the background?

Mike

Re: checking the matching text in the database

jeyanthi — Tue, 20 May 2008 06:05:57 GMT

hi mike i'm goin for the second option.

let say the user insert the stnid.

now i have to check the database is the stnid is already stored or not stored.

if stored i must pop up a message tell tht the number is already in use and user have to insert another stnid.

Re: checking the matching text in the database

MikeS81 — Tue, 20 May 2008 06:17:31 GMT

Hi jeyanthi,

is it a "real" database or a text file? If you have a database you can send an SQL command to it which search for your string. If you have a text file, then you can read in the data, and use for example the match pattern function.

Mike

Message Edited by MikeS81 on 05-20-2008 08:17 AM

Re: checking the matching text in the database

jeyanthi — Tue, 20 May 2008 06:59:36 GMT

Hi again.. sry to disturb if i use the 1st method without the user not doin anythg wen the data from text file convert to text file...is it can be dono using queries only.

Re: checking the matching text in the database

MikeS81 — Tue, 20 May 2008 07:23:56 GMT

jeyanthi wrote:

...is it can be dono using queries only.

Hi jeyanthi,

i don´t understand it.

If you use the textfile method, you can for example store the last automatic used number. And if you need it you increase it and create the new number. Write the last used number at the end of your program to the file, so that you can read it the next time you start. Another soultion could be to scan the file for the last automatic used number.

Mike

Re: checking the matching text in the database

jeyanthi — Wed, 21 May 2008 10:31:31 GMT

let say i have stnid as unique key in database...how to check tht the station number already inserted to the database.

i have attach the text file and the vi. i use

in the vi i pass the data to two tables one is stationlogews and stationinfoews.

for stationlogews i dont have any problem currently.

for stationinfoews it has to stationnumber as unique let say sed001 is inserted it not should insert again the same number..

how to do tht?

and let say all the data is inserted to the database.. how to stop it from inserting for the second time running..

Re: checking the matching text in the database

MikeS81 — Wed, 21 May 2008 10:48:59 GMT

Hi jeyanthi,

as a first step read your data. Than use the spreadsheet string to array function, you can use ";" as seperator. Delete all empty lines (onyl before and after a text block) and read your specified position where you expect the sed00x entry and create an array of them. Then you can may be sort this array and check if an entry is already there.

Mike

Re: checking the matching text in the database

MikeS81 — Wed, 21 May 2008 11:55:14 GMT

Hi jeyanthi,

it´s a little bit different as my description, but here is an example, which shows how you can read your sed elements.

Hope it helps.
Mike

Re: checking the matching text in the database

jeyanthi — Thu, 22 May 2008 04:03:59 GMT

thk u ..it look better than mine...

i have another doubt let say i have empty field in the sed element,

how i can store it as SED9999, SED9999-1,...how to do tht????

Re: checking the matching text in the database

MikeS81 — Thu, 22 May 2008 06:06:19 GMT

Hi jeyanthi,

connect your data to a for loop and check for an empty element. If it is empty, use the "Format into String" function to create your new value.

Mike

Message Edited by MikeS81 on 05-22-2008 08:06 AM

Calling the same function after one button dialog

jeyanthi — Fri, 23 May 2008 02:27:51 GMT

hi need help ..how to call the same function if i use one button dialog .

need help plz.thk u

Re: Calling the same function after one button dialog

MikeS81 — Fri, 23 May 2008 06:55:07 GMT

Hi jeyanthi,
when do you call this dialog? Why do you now speak about a database, i thought your data is from a text file? Can you please explain the relation between your text file and the database?

Mike

Re: Calling the same function after one button dialog

jeyanthi — Fri, 23 May 2008 09:30:30 GMT

hi Mike ..i have been ask to replace the auto inserting sed num to manual..

example user have to insert a number by himself and aftr he insert i have ti check whethr the number already inserted or not.. tht y i called the function and dont knw how to call the same vi recursively...

Re: Calling the same function after one button dialog

MikeS81 — Fri, 23 May 2008 12:16:37 GMT

Hi jeyanthi,
here is a simple solution for you. I use the express vi to prompt for input, for a quick example, you can change it with your customized input vi.

Hope it helps.
Mike