Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
How to set other driver properties like Use Case Sensitive Searchs property |
Author |
Message |
|
Posted : 2006-06-29 08:35:21 |
I search the database using the Customer FullName field. It took me a while to notice that it is a casesensitive field. Now, I want to set the case Sensitive driver option, Unfortunately, I did not fine information about it.
Summary
How can I set the properties of the driver using properties? Or is ther a better way to do that? I Use Citrix in a client/server environment with several machines. I do not want to configure the ODBC driver in all machines.
Thanks,
Joao, |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-29 10:57:57 |
See: How do I setup QODBC? What are the setup options? for all the setup options for QODBC.
Use Case Sensitive RefNumber Searches when checked means a refnumber of 'ABC' and 'abc' will be different, but means QuickBooks can use an index internally for a search instead of a complete table scan. (Note: this feature applies to versions of QuickBooks 2005 and higher)
|
|
|
|
|
Posted : 2006-07-06 04:11:04 |
Ok. But The question is , how can I do it through the connection parameters? As I said I have more than one machine, I do not want to set those properties wherever I install the driver. I just want to send all that I can thru the connection parameters. Something like :
Driver={QODBC Driver for QuickBooks}; DFQ=d:\data\sample04.qbw; OpenMode=M; Case Sensitive = NO;
thanks, Joao,
Joao, |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-06 10:39:04 |
|
|
|
|