--- In qodbc@yahoogroups.com, "twarwick1" <Terry@...> wrote:
>
> Hi,
>
> We are using the UK QuickBooks 2006 Pro version with a company data file that
has multi-currency switched-on. Does anyone know if it's possible to use QODBC
to switch-off multi-currency for our company data file and where in the tables
this switch exists? Thanks for your help.
>
> Terry
>

Not possible... and probably good that it isn't... too many ramifications if
that happened in error.

Hi,

We are using the UK QuickBooks 2006 Pro version with a company data file that
has multi-currency switched-on. Does anyone know if it's possible to use QODBC
to switch-off multi-currency for our company data file and where in the tables
this switch exists? Thanks for your help.

Terry

Try using {d'2009-05-31'} format on the TxnDate field.








Robert Noche
Diskmate Bookkeeping and Tax Services
CTEC Registered Tax Preparer
Certified Quickbooks Pro Advisor
Member - American Institute of Professional Bookkeepers
Brainbench Certified in Financial Accounting, Bookkeeping and Payroll

8350 Archibald Ave. Ste. 230
Rancho Cucamonga, CA 91730
Tel: (909) 972-3051
Fax: (909) 972-6916
Email: rnoche@...
Web: www.diskmate.net

  <http://www.diskmate.net/diskmate%20map.bmp> Office Map



From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
lkside79
Sent: Tuesday, June 02, 2009 7:59 PM
To: qodbc@yahoogroups.com
Subject: [qodbc] INSERT INTO Query Problem








I'm using the QODBC Server 9.0 Driver and trying to perform the following
query. I have looked at it to long and need some else to look please help.

Everytime I try some version of this I get this error - Invalid operand for
operator: <assignment>

INSERT INTO SalesOrderLine
(CustomerRefFullName,TxnDate,BillAddressAddr1,BillAddressAddr2,BillAddressCi
ty,BillAddressState,BillAddressPostalCode,PONumber,SalesOrderLineItemRefFull
Name,SalesOrderLineQuantity,SalesOrderLineRate,FQSaveToCache) VALUES ('BED,
BATH AND BEYOND','2009-05-31','650 LIBERTY AVE','ANNEX
BLDG','UNION','NJ','07083','VM24860','38-512','6','4.22',1)

Thank you for any help,

Cory





[Non-text portions of this message have been removed]

yes - we included the sp_reports, and although they are somewhat difficult
to reformat, being report images instead of tables, often they include
information calculated by QuickBooks and not available in the database.
brad

On Sat, Jun 13, 2009 at 10:29 PM, sheaschultze <Shea@...>wrote:

>
>
> I've never seen that figure in a table.
> Perhaps you can run the Aging sp_report as of your end date and capture the
> customers from those results.
> (I have found duplicating the Aging report in SQL and/or VB to be
> surprisingly involved. )
>
> --- In qodbc@yahoogroups.com <qodbc%40yahoogroups.com>, "twarwick1"
> <Terry@...> wrote:
> >
> > UK QuickBooks Pro 2008/Visual Basic 6 and Access 2003
> >
> >
> > Hi,
> >
> > I am running the "sp_report Txn List By Customer" in VB6 to create a list
> of monthly statements but need to find the outstanding balance as of the end
> of the previous month to show on the statement. (This shows on the menu way
> to create Statements in QuickBooks so need to replicate this.) As far as I
> can see, this information is not contained in any field in the columns for
> this sp_report. From little knowledge and a little digging I can probably
> calculate the outstanding balance from taking all (previous outstanding)
> Invoice's and finding which ones have been paid by matching them to the
> InvoiceLineTxn. Finally to my question: does anyone know if the outstanding
> balance figure is stored in the QuickBooks tables and where? Thank you for
> your help.
> >
> > Terry
> >
>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww


[Non-text portions of this message have been removed]

I've never seen that figure in a table.
Perhaps you can run the Aging sp_report as of your end date and capture the
customers from those results.
(I have found duplicating the Aging report in SQL and/or VB to be surprisingly
involved.  )
--- In qodbc@yahoogroups.com, "twarwick1" <Terry@...> wrote:
>
> UK QuickBooks Pro 2008/Visual Basic 6 and Access 2003
>
>
> Hi,
>
> I am running the "sp_report Txn List By Customer" in VB6 to create a list of
monthly statements but need to find the outstanding balance as of the end of the
previous month to show on the statement. (This shows on the menu way to create
Statements in QuickBooks so need to replicate this.) As far as I can see, this
information is not contained in any field in the columns for this sp_report.
From little knowledge and a little digging I can probably calculate the
outstanding balance from taking all (previous outstanding) Invoice's and finding
which ones have been paid by matching them to the InvoiceLineTxn. Finally to my
question: does anyone know if the outstanding balance figure is stored in the
QuickBooks tables and where? Thank you for your help.
>
> Terry
>

cory
my guess is the comma inside the first field.

Our technical support system is best staffed by those who can help with this
question, please see the FAQ search and support ticket system for help on
this issue:

http://support.FLEXquarters.com

thanks

Brad Waddell
Product Manager, QODBC the ODBC Driver for QuickBooks
www.QODBC.com


On Wed, Jun 3, 2009 at 10:58 AM, lkside79 <corygs@...> wrote:

>
>
> I'm using the QODBC Server 9.0 Driver and trying to perform the following
> query. I have looked at it to long and need some else to look please help.
>
> Everytime I try some version of this I get this error - Invalid operand for
> operator: <assignment>
>
> INSERT INTO SalesOrderLine
>
(CustomerRefFullName,TxnDate,BillAddressAddr1,BillAddressAddr2,BillAddressCity,B\
illAddressState,BillAddressPostalCode,PONumber,SalesOrderLineItemRefFullName,Sal\
esOrderLineQuantity,SalesOrderLineRate,FQSaveToCache)
> VALUES ('BED, BATH AND BEYOND','2009-05-31','650 LIBERTY AVE','ANNEX
> BLDG','UNION','NJ','07083','VM24860','38-512','6','4.22',1)
>
> Thank you for any help,
>
> Cory
>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww


[Non-text portions of this message have been removed]

terry,
run the previous month report and save it to get the ending figures from
that month.

Our technical support system is best staffed by those who can help with this
question, please see the FAQ search and support ticket system for help on
this issue:

http://support.FLEXquarters.com

thanks

Brad Waddell
Product Manager, QODBC the ODBC Driver for QuickBooks
www.QODBC.com


On Sat, Jun 13, 2009 at 4:08 PM, twarwick1 <Terry@...> wrote:

>
>
> UK QuickBooks Pro 2008/Visual Basic 6 and Access 2003
>
> Hi,
>
> I am running the "sp_report Txn List By Customer" in VB6 to create a list
> of monthly statements but need to find the outstanding balance as of the end
> of the previous month to show on the statement. (This shows on the menu way
> to create Statements in QuickBooks so need to replicate this.) As far as I
> can see, this information is not contained in any field in the columns for
> this sp_report. From little knowledge and a little digging I can probably
> calculate the outstanding balance from taking all (previous outstanding)
> Invoice's and finding which ones have been paid by matching them to the
> InvoiceLineTxn. Finally to my question: does anyone know if the outstanding
> balance figure is stored in the QuickBooks tables and where? Thank you for
> your help.
>
> Terry
>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww


[Non-text portions of this message have been removed]

I'm using the QODBC Server 9.0 Driver and trying to perform the following query.
I have looked at it to long and need some else to look please help.

Everytime I try some version of this I get this error - Invalid operand for
operator: <assignment>

INSERT INTO SalesOrderLine
(CustomerRefFullName,TxnDate,BillAddressAddr1,BillAddressAddr2,BillAddressCity,B\
illAddressState,BillAddressPostalCode,PONumber,SalesOrderLineItemRefFullName,Sal\
esOrderLineQuantity,SalesOrderLineRate,FQSaveToCache) VALUES ('BED, BATH AND
BEYOND','2009-05-31','650 LIBERTY AVE','ANNEX
BLDG','UNION','NJ','07083','VM24860','38-512','6','4.22',1)

Thank you for any help,

Cory

UK QuickBooks Pro 2008/Visual Basic 6 and Access 2003


Hi,

I am running the "sp_report Txn List By Customer" in VB6 to create a list of
monthly statements but need to find the outstanding balance as of the end of the
previous month to show on the statement. (This shows on the menu way to create
Statements in QuickBooks so need to replicate this.) As far as I can see, this
information is not contained in any field in the columns for this sp_report.
From little knowledge and a little digging I can probably calculate the
outstanding balance from taking all (previous outstanding) Invoice's and finding
which ones have been paid by matching them to the InvoiceLineTxn. Finally to my
question: does anyone know if the outstanding balance figure is stored in the
QuickBooks tables and where? Thank you for your help.

Terry

pretty sure thats in the company file - but the UK version lags behind in
SDK support so you may have to upgrade your QuickBooks version to get that
information. try downloading a 2009 QuickBooks UK eval and testing qodbc
against it (eval mode). Or you can post to our new support system:
http://support.flexquarters.com

brad

On Thu, Apr 23, 2009 at 8:25 PM, twarwick1 <Terry@...> wrote:

>
>
> Hi,
>
> I am Visual Basic developer using the UK vesion of QuickBooks Pro 2006 and
> QODBC to create reports and need to find which table in QuickBooks has the
> UK company VAT number stored - Can anyone help? Thanks
>
> Terry (twarwick1)
>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww


[Non-text portions of this message have been removed]

Hi,

I am Visual Basic developer using the UK vesion of QuickBooks Pro 2006 and QODBC
to create reports and need to find which table in QuickBooks has the UK company
VAT number stored - Can anyone help? Thanks

Terry (twarwick1)

the most common date format is this one:

DateFrom = {d'2007-01-01'}, DateTo= {d'2008-01-01'}

i found this by doing a search of our web support system from
qodbc.com - it was the first post listed.

brad


On Thu, Dec 25, 2008 at 3:52 AM, Robert <rob_jurado@...> wrote:
> and again, I misspelled it.... it is "ModifiedTime". The problem
> still is cause by the operant ">" (or any) so I am thinking that the
> format is different. Thanks ahead for any response.
>
> --- In qodbc@yahoogroups.com, "Robert" <rob_jurado@...> wrote:
>>
>> Oh... my mistake on my copy-paste.
>>
>> Actaully it is like this
>>
>> "SELECT Top 10* FROM Customer where ModifiedTiem > '2008-12-22'"
>>
>> but it still gives me the same error.
>>
>> Any ideas
>>
>>
>> --- In qodbc@yahoogroups.com, Brad <bradwww@> wrote:
>> >
>> > you need something on the left side of the comparison, like this:
>> >
>> > "SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"
>> >
>> > to see the date format, run a select * from customer
>> >
>> > brad
>> >
>> > On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@> wrote:
>> > > Does anyone know the syntax for date fields on the where clause?
>> > >
>> > > I am trying to query this:
>> > >
>> > > "SELECT Top 10* FROM Customer where > '2008-12-22'"
>> > >
>> > > but it is giving me the following error:
>> > > ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
>> > >
>> > > Thank you.
>> > >
>> > >
>> >
>> >
>> >
>> > --
>> > Brad Waddell, Managing Director
>> > FLEXquarters.com Limited
>> > Skype: bradwww
>> >
>>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww

and again, I misspelled it.... it is "ModifiedTime".  The problem
still is cause by the operant ">" (or any) so I am thinking that the
format is different.  Thanks ahead for any response.




--- In qodbc@yahoogroups.com, "Robert" <rob_jurado@...> wrote:
>
> Oh... my mistake on my copy-paste.
>
> Actaully it is like this
>
> "SELECT Top 10* FROM Customer where ModifiedTiem > '2008-12-22'"
>
> but it still gives me the same error.
>
> Any ideas
>
>
> --- In qodbc@yahoogroups.com, Brad <bradwww@> wrote:
> >
> > you need something on  the left side of the comparison, like this:
> >
> > "SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"
> >
> > to see the date format, run a select * from customer
> >
> > brad
> >
> > On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@> wrote:
> > > Does anyone know the syntax for date fields on the where clause?
> > >
> > > I am trying to query this:
> > >
> > > "SELECT Top 10* FROM Customer where > '2008-12-22'"
> > >
> > > but it is giving me the following error:
> > > ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
> > >
> > > Thank you.
> > >
> > >
> >
> >
> >
> > --
> > Brad Waddell, Managing Director
> > FLEXquarters.com Limited
> > Skype: bradwww
> >
>

the date format can vary depending on the tool you are using, it
should be listed in the  SQL/ODBC syntax of your product
documentation.

or as i said last time, export the data and view the date format, and
copy this as an example.

brad

On Thu, Dec 25, 2008 at 3:47 AM, Robert <rob_jurado@...> wrote:
> Oh... my mistake on my copy-paste.
>
> Actaully it is like this
>
> "SELECT Top 10* FROM Customer where ModifiedTiem > '2008-12-22'"
>
> but it still gives me the same error.
>
> Any ideas
>
> --- In qodbc@yahoogroups.com, Brad <bradwww@...> wrote:
>>
>> you need something on the left side of the comparison, like this:
>>
>> "SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"
>>
>> to see the date format, run a select * from customer
>>
>> brad
>>
>> On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@...> wrote:
>> > Does anyone know the syntax for date fields on the where clause?
>> >
>> > I am trying to query this:
>> >
>> > "SELECT Top 10* FROM Customer where > '2008-12-22'"
>> >
>> > but it is giving me the following error:
>> > ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
>> >
>> > Thank you.
>> >
>> >
>>
>>
>>
>> --
>> Brad Waddell, Managing Director
>> FLEXquarters.com Limited
>> Skype: bradwww
>>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww

Oh... my mistake on my copy-paste.

Actaully it is like this

"SELECT Top 10* FROM Customer where ModifiedTiem > '2008-12-22'"

but it still gives me the same error.

Any ideas


--- In qodbc@yahoogroups.com, Brad <bradwww@...> wrote:
>
> you need something on  the left side of the comparison, like this:
>
> "SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"
>
> to see the date format, run a select * from customer
>
> brad
>
> On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@...> wrote:
> > Does anyone know the syntax for date fields on the where clause?
> >
> > I am trying to query this:
> >
> > "SELECT Top 10* FROM Customer where > '2008-12-22'"
> >
> > but it is giving me the following error:
> > ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
> >
> > Thank you.
> >
> >
>
>
>
> --
> Brad Waddell, Managing Director
> FLEXquarters.com Limited
> Skype: bradwww
>

you need something on  the left side of the comparison, like this:

"SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"

to see the date format, run a select * from customer

brad

On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@...> wrote:
> Does anyone know the syntax for date fields on the where clause?
>
> I am trying to query this:
>
> "SELECT Top 10* FROM Customer where > '2008-12-22'"
>
> but it is giving me the following error:
> ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
>
> Thank you.
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww

Does anyone know the syntax for date fields on the where clause?

I am trying to query this:

"SELECT Top 10* FROM Customer where > '2008-12-22'"

but it is giving me the following error:
ERROR [S0000] [QODBCPOS] Invalid operand for operator: >


Thank you.

A client of mine just upgraded from Office 2000 to Office 2003.  In my
application the user will run a deposit routine that posts to the
Deposit and DepositDetail tables in QuickBooks 2003.

With the upgrade to Office 2003 the QODBC driver cannot connect to
QuickBooks unless QuickBooks is open.  Why would the Office upgrade
cause the QODBC driver to fail when QuickBooks is closed?

Thanks.

QuickBooks versions 2002 and higher support add-on products like
QODBC, i think version 5 is from around 1998.

brad

--- In qodbc@yahoogroups.com, "Dan" <dgustavsen@...> wrote:
> Hello,
>
> Will the current version of QODBC (8) work with QuickBooks version 5?
>
> Thanks,
> Dan
>

Hello,

Will the current version of QODBC (8) work with QuickBooks version 5?

Thanks,
Dan

I am working remotely with an office in Tokyo. They have an
installation of QuickBooks 7.0 and routinely enter addresses and names
in Japanese with little trouble.

Using the 7.0 version of QODBC I am pulling customer info into another
application using VB 6. The English characters come over fine, but the
Japanese characters are garbled. I stongly suspect that QODBC is unable
to bring unicode characters over.

Does anyone have any ideas?

hi tim

please post your extremely well researched question to our support
forum at forum.qodbc.com for immediate action. we did have to make
changes to the 8.0 driver speed because of accuracy issues in
QuickBooks SDK, you can get more details from tom. thanks!

brad

--- In qodbc@yahoogroups.com, "avalon_acres_farms" <farmer@...> wrote:
>
> I have been running a MS Access with Quickbooks Enterprise for awhile
> now pretty successfully.  I have written customized queries and
> packing lists with it because I don't like they way the standard
> packing lists look in Quickbooks.
>
> For the last year I have been using QB 7.0 with the QODBC driver that
> came along with it.  I have had two problems that have been solved by
> the "reload all data" funtion in the QODBC reconfiguration tool.  1)
> Sometimes credits do not show up in Access unless I reload and 2)
> there have been a few times where reports take WAY TOO LONG to run
> (30 minutes instead of 30 seconds).
>
> I recently rebuilt my entire PC from the operating system up and
> installed QB 8.0 with the corresponding QOBDC 8.0 driver.  I am now
> experiencing an enormous speed problem.  The new optimizer (8.0)
> seems to run a lot slower, but since I do that overnight it is not my
> biggest problem.  The real problem is that reports take 30 minutes to
> an hour to run.  No matter what I do I can not solve it.  I have
> tried everything I can think of:
>
> 1) I turned off all firewalls, visus checking, registry checkers
> 2) All the latest software updates are installed
> 3) I have tried running "reload all data"
> 4) I tried rebuilding the Quickbooks file
> 5) I tried creating a new Access database and re-linking to the QB
> program
> 5) I tried refreshing all the links.
> 6) I have made sure nothing else is running and competing with Access
> and Quickbooks.  I did this by CTRL-ALT-DEL and watching all the
> processes.  All I see is two Quickbooks files and MS Access trading
> back and forth and DOMINATING the CPU processor staying pegged at
> 100%.
> 7) I have turned off the optimizer and deleting the .OPT file
> 8) I have played with settings in the OBDC configuration tool with no
> improvement.
> 9) I tried re-sorting (re-indexing) all the tables in Quickbooks
> 10) I turned on the verbose feature and it cranks through 500 records
> and then just sits there for a couple minutes then repeats.
>
> The reports do eventually run, but the time lag is totally
> unacceptable.  The only success I had in getting these reports to run
> was to "import" the tables... that took a couple hours, but then all
> the reports ran almost instantaneously.  It is, however a
> workaround.  If someone puts in a last minute order before our build,
> I will no longer be able to accomodate it.  Before since the table
> was  linked, I could put in a last minute order and it would be
> reflected in my Access reports.
>
> I turned on "verbose" and the "driver status panel"... and it sits
> there for long periods of time saying "waiting on Quickbooks" and the
> CPU stays pegged at 100%.  The hard drive isn't spanking or
> anything... just the CPU... and waiting and waiting and waiting.  The
> optimizer is set for not going off every time, so that's not what's
> holding up the whole show... it just sits there and cranks through
> the records real slow.  When I spread out the status panels, I can
> see what's going on... sometimes it sits there, but usually it's
> doing something... but just slow... almost like 1 record per second.
>
> This QODBC functionality was precisely why I bought Quickbooks
> Enterprise.  I spent thousands on it and pay $750 a year to have it
> maintained.  I was pretty pleased with how easy it was to use it and
> it gave me good results with minimal effort for a whole year... all I
> had to do was to create reports and queries in Access which I already
> knew how to do.  Now it seems I must delve into a whole new level of
> tweaking that I never had to do before like making pass-through
> queries and using NOSYNC.
>
> I never had to do this before and it worked decent.... now it is
> virtually unuseable.  I am not getting good help from www.qodbc.com
> and I hope someone here can help.
>
> I am desperate and frustrated... I need help to get this resolved.
>
> Please help.
>
> Tim
>

I have been running a MS Access with Quickbooks Enterprise for awhile
now pretty successfully.  I have written customized queries and
packing lists with it because I don't like they way the standard
packing lists look in Quickbooks.

For the last year I have been using QB 7.0 with the QODBC driver that
came along with it.  I have had two problems that have been solved by
the "reload all data" funtion in the QODBC reconfiguration tool.  1)
Sometimes credits do not show up in Access unless I reload and 2)
there have been a few times where reports take WAY TOO LONG to run
(30 minutes instead of 30 seconds).

I recently rebuilt my entire PC from the operating system up and
installed QB 8.0 with the corresponding QOBDC 8.0 driver.  I am now
experiencing an enormous speed problem.  The new optimizer (8.0)
seems to run a lot slower, but since I do that overnight it is not my
biggest problem.  The real problem is that reports take 30 minutes to
an hour to run.  No matter what I do I can not solve it.  I have
tried everything I can think of:

1) I turned off all firewalls, visus checking, registry checkers
2) All the latest software updates are installed
3) I have tried running "reload all data"
4) I tried rebuilding the Quickbooks file
5) I tried creating a new Access database and re-linking to the QB
program
5) I tried refreshing all the links.
6) I have made sure nothing else is running and competing with Access
and Quickbooks.  I did this by CTRL-ALT-DEL and watching all the
processes.  All I see is two Quickbooks files and MS Access trading
back and forth and DOMINATING the CPU processor staying pegged at
100%.
7) I have turned off the optimizer and deleting the .OPT file
8) I have played with settings in the OBDC configuration tool with no
improvement.
9) I tried re-sorting (re-indexing) all the tables in Quickbooks
10) I turned on the verbose feature and it cranks through 500 records
and then just sits there for a couple minutes then repeats.

The reports do eventually run, but the time lag is totally
unacceptable.  The only success I had in getting these reports to run
was to "import" the tables... that took a couple hours, but then all
the reports ran almost instantaneously.  It is, however a
workaround.  If someone puts in a last minute order before our build,
I will no longer be able to accomodate it.  Before since the table
was  linked, I could put in a last minute order and it would be
reflected in my Access reports.

I turned on "verbose" and the "driver status panel"... and it sits
there for long periods of time saying "waiting on Quickbooks" and the
CPU stays pegged at 100%.  The hard drive isn't spanking or
anything... just the CPU... and waiting and waiting and waiting.  The
optimizer is set for not going off every time, so that's not what's
holding up the whole show... it just sits there and cranks through
the records real slow.  When I spread out the status panels, I can
see what's going on... sometimes it sits there, but usually it's
doing something... but just slow... almost like 1 record per second.

This QODBC functionality was precisely why I bought Quickbooks
Enterprise.  I spent thousands on it and pay $750 a year to have it
maintained.  I was pretty pleased with how easy it was to use it and
it gave me good results with minimal effort for a whole year... all I
had to do was to create reports and queries in Access which I already
knew how to do.  Now it seems I must delve into a whole new level of
tweaking that I never had to do before like making pass-through
queries and using NOSYNC.

I never had to do this before and it worked decent.... now it is
virtually unuseable.  I am not getting good help from www.qodbc.com
and I hope someone here can help.

I am desperate and frustrated... I need help to get this resolved.

Please help.

Tim

Dates have a specific format requirement for being passed within the
WHERE clause:
{d'YYY-MM-DD'}

So, you need to format your fiel as appropriate so that it can be passed
in that fashion.  It's a royal pain, but if you want to use dates in
your queries, you have to go through this process.

________________________________

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
sheaschultze
Sent: Monday, September 03, 2007 8:06 AM
To: qodbc@yahoogroups.com
Subject: [qodbc] Date Format in Where Statement of Pass Thru Query



Hi. I have the latest versions of the driver and QuickBooks
Enterprise 7. I use Access 2003. Pass Thru queries work just great
until I try to restrict by date.

This works perfect:
SELECT *
FROM InvoiceLine UNOPTIMIZED
WHERE ClassRefFullName = "001-Gfeller"

This fails:
SELECT *
FROM InvoiceLine UNOPTIMIZED
WHERE TxnDate = ????!!!!????

I've tried different bracketing:
(), {}, [], " ", ' ', ##
I've tried different date formats:
YYYY-MM-DD, YYYY-DD-MM, YYYYMMDD, MM/DD/YY, MM/DD/YYYY, etc.

Got a variety of different error messages like Unexpected Literal,
or etc.

Any suggestions?

Hi.  I have the latest versions of the driver and QuickBooks
Enterprise 7.  I use Access 2003.  Pass Thru queries work just great
until I try to restrict by date.

This works perfect:
SELECT *
FROM InvoiceLine UNOPTIMIZED
WHERE ClassRefFullName = "001-Gfeller"

This fails:
SELECT *
FROM InvoiceLine UNOPTIMIZED
WHERE TxnDate = ????!!!!????

I've tried different bracketing:
(), {}, [], " ", ' ', ##
I've tried different date formats:
YYYY-MM-DD, YYYY-DD-MM, YYYYMMDD, MM/DD/YY, MM/DD/YYYY, etc.

Got a variety of different error messages like Unexpected Literal,
or etc.

Any suggestions?

Yep I am here Shea... I had partnered with FLEXquarters for three
years leading up to the inclusion into Enterprise.  I now consult with
Intuit - and teach classes - on its use and presentation.

I am sure that FLEXquarters will be happy to accommodate your request.
  Many of those options will also depend upon the particular use.

Good luck!

Chuck

--- In qodbc@yahoogroups.com, "sheaschultze" <Shea@...> wrote:
>
> Chuck Vigeant?  Are you here as well?
>
> We are having quite a bit of success using QODBC to transfer QB ES
> data to an .opt file using Optimization and then transferring the
> data to MSAccess.  Thank you for this product!  I've spoken with
> quite a few people online support chat groups and in person at the
> Intuit Users Conference in San Diego.  I would like additional
> information that does not seem to be in the users manuels nor in the
> white papers.
>
> Specifically I would like to discuss the impact of changing various
> options on the Configure ODBC screens in QB ES File/Utilities menu.
>
> Please refer this request to someone in your organization with
> advanced knowledge of these setup variables.  Please have him/her
> call my office between 5AM to 6PM PST.  I understand this call might
> be subject to support charges.
>
> Shea Schultze
> Renaissance Executive Forums, Inc.
> 7855 Ivanhoe Avenue, Suite 300
> La Jolla, CA  92037
> (858)551-6607
>

I have historical data that need to be recreated in Quickbooks Pro.

Would appreciate any advice if the above can be automated with QODBC
and HOW.

Chuck Vigeant?  Are you here as well?

We are having quite a bit of success using QODBC to transfer QB ES
data to an .opt file using Optimization and then transferring the
data to MSAccess.  Thank you for this product!  I've spoken with
quite a few people online support chat groups and in person at the
Intuit Users Conference in San Diego.  I would like additional
information that does not seem to be in the users manuels nor in the
white papers.

Specifically I would like to discuss the impact of changing various
options on the Configure ODBC screens in QB ES File/Utilities menu.

Please refer this request to someone in your organization with
advanced knowledge of these setup variables.  Please have him/her
call my office between 5AM to 6PM PST.  I understand this call might
be subject to support charges.

Shea Schultze
Renaissance Executive Forums, Inc.
7855 Ivanhoe Avenue, Suite 300
La Jolla, CA  92037
(858)551-6607

Hello, I'm new using QODBC. I'm programming in Delphi and using an ADO
connection to QODBC.  I'm sending information to quickbooks to create an
Estimate. Everything works fine, but this takes aproximately 4 minutes. Which is
a lot if we consider that I'm only using one select to the customers table and
like five inserts to create the Estimate's rows.

   The time it takes, Is it normal?
   Does anybody knows if there is another way to connect to the QODBC, besides
ADO??

   Any suggestions are welcome...
   Thanks.
   AG





---------------------------------
Luggage? GPS? Comic books?
Check out fitting  gifts for grads at Yahoo! Search.

[Non-text portions of this message have been removed]

I want to set up a report criteria sheet in Excel. One of the criteria
items would be the month to be pulled from QuickBooks.

How can I setup a 'sp_report ProfitAndLossStandard' query (or any
sp_report query) to have the 'DateFrom' and 'DateTo' parameters look to
the value of a cell or cells to get the data rather than having to
manually modify the query in MS Query?

Thanks!

--
Bronson