Search results for query: *

Sean, I've been experiencing the same problem and your report really helped me! Thank you so much. Ricardo

Ido, I have no dummy columns, the tables are really different. Thanks.

Ido, I have no dummy columns, the tables are really different.

Thanks, synapsevampire. But the union query is not possible because the select statements I need have different number of columns. Any other idea?

I'm using Crystal Reports 4.6.1 with an ODBC database. I need to use the option "Link options/Look up all of one, then all of other", but it's not available for ODBC databases. Can anyone tell me how to reproduce that behaviour for an ODBC database? Thanks.

bastienk, I cannot use soundex because I must use a "generic" sentence, which can be passed to any DBMS other than MySQL.

I need to use character_set=dos in my server (MySQL 4.0.16). But there is a side effect: searches become access sensitive. So if I search for a name "José" it returns only "José" and I want it to return "Jose" and "José". This was the behaviour when I was using character_set=latin1. Can anyone...

Thanks for your reply, vb5prgrmr. I haven't read the FAQ222-2244. But the link you inserted points to Tek-Tips home page... can you tell me the right link? I do use update in the full code, but the lock error happens before it is reached (in the line in which the value of the field is set)...

Also tb and tb2 are different tables... Thank you.

Correcting: User1: ------- tb.lockedits=false tb.edit (...) tb("MyMemo").value = Value$ User2: ------- tb2.lockedits=false ''CORRECTED HERE tb2.edit ''CORRECTED HERE (...) tb2("OtherMemo").value = Value$

I'm using VB 5, JET 3.5 and a 2.0 Access database in a multiuser environment. I have a memo field which keeps a large ammount of text on each record. Setting the memo field value delays a bit (no problem), and I noticed that, while processing it, the JET engine keeps locking even if lockedits...

Thanks dswitzer. The query you've suggested works perfectly if I run it from MS SQL Server Query Analyser. And it also works if I run it from Visual Basic using an ODBCDirect data source. The original query ("SELECT field1 FROM table1 UNION SELECT field2 FROM table2") works this way...

Thank you for the reply, FredPerry. Sorry, I made a mistake when I wrote the message. The individual queries are: "SELECT field1 FROM table1" and "SELECT field2 FROM table2" I'm sure tables and fields exist, I have permission to access them, and both Field1 and Field2 are...

Hi, I have a database stored in MS SQL 2000 and an application written in VB5, which connects the database via JET/ODBC. I have a problem with the UNION statement. When I run a simple query like: "SELECT field1 FROM table1 UNION SELECT field2 FROM table2" I get the following...