Comments by Tieko - CodeProject

Tieko 8-Jul-24 14:40pm View

& instead of "+". This was the error. Now i have 5 different codes working. Thanks Dave.
(now i go to build index) - Thank you very much.

Tieko 8-Jul-24 14:05pm View

I wrote it. The database is composed of one column named "Sequenza" varchar(200).
During program execution i obtain a string (more smaller than the string into db) that i must compare using LIKE to discover if there is a db row that starts with the same text and finish (is not important. so i was using like cIndicatorex% .

Example : cIndicatorex="12345"
scan the db and if you find "1234567890" returns true or found 1 or something so i know it was found. just that.
Thanks in advance Dave.

Tieko 8-Jul-24 13:22pm View

After lot of tries i think that Dave has found the point. I don't do correct variables substitution. The code is correct, db is opened, command (scalar) are executed , but values returned are wrong also if present in db. So i think that due to not correct variable sobstitution, the query is not correct. Can you help me Dave about? where i can look?

Tieko 8-Jul-24 12:54pm View

Thank you again. I will try. But it seems that the problem is how i send commands. so , knowing the right command is not enough. look at this version : it seems to be ok, but does not find the string (that is present in the form "12345678" into Db). Huge timout is present due to a db of 120 millions of records.

Tieko 8-Jul-24 12:05pm View

Thank you. I don't need to catch field of matching rows. I just need to know if in the DB there is a string that contains my search string. cStrToFind was here as example. In the reality i have a code that build the search string, go to the db to see if there is or not. So i must put it into a variable , i cannot type it becaus the string change everytime. is there a way to know (true/false/number of matching rows)?

Tieko 8-Jul-24 10:15am View

Hi Richard, it was VS 2022, a mistake. Thanks for signaling.
The first code block (one of the many i tried) is searching with the VARIABLE 'cIndicatorx' (this was my idea, if it is wrong tell me) and the second the same thing with another name.
i have a variable cIndicatorx (or something else) that contains a string, and i must find IF the string is present in the db.

Regarding the ExecuteNonQuery i trie all execute possibile but no one works. There is a special Execute for select so i can trace if found or not?

Note that my cIndicatorx string is shorter than the string in the db, so i used LIKE and the % after the last char.
Thanks in advance.

Comments by Tieko (Top 6 by date)