Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: loRdK
  • Order by date
  1. loRdK

    Failing to update linked table

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

    Link options

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

    Link options

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

    Link options

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

    Link options

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

    Searches are access sensitive if character_set = dos

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

    Searches are access sensitive if character_set = dos

    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...
    • loRdK
    • Thread
    • Replies: 2
    • Forum: MySQL
  8. loRdK

    Memo fields lock

    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)...
  9. loRdK

    Memo fields lock

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

    Memo fields lock

    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$
  11. loRdK

    Memo fields lock

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

    UNION statement doesn't work

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

    UNION statement doesn't work

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

    UNION statement doesn't work

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

Part and Inventory Search

Back
Top