David, I have QBDataDirect but frankly haven't used it. I discovered I really need the one above.
In my opinion your questions can only be answered by you playing with it. Jan Johansen -----Original Message----- From: "David Blocker" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 2 Apr 2008 12:45:35 -0400 Subject: [RBASE-L] - NO one has used RQBDataDirect???!!! Hi All 2 days ago I posted these questions about using RQBDataDirect, the new plugin to export files to QuickBooks. The list has been vocal, but silent on this question. Is it really true that NO one has used it yet? Razzak, can you chime in? Here's what I posted: >>I'm looking for someone out there who has actually used the new R:Base >>product RQBDataDirect to export data to QuickBooks. I'm preparing a >>proposal for a customer who wants to export invoice information to >>Quickbooks. Looking at the documentation for RQBDataDirect, I have 3 questions. 1. Am I correct in assuming that since RQBDataDirect does not support expressions, if I wanted to export, for example, all invoices for a certain date, I could NOT use a WHERE clause like "WHERE InvDate = .#Date". Instead I would have to add a Flag column to the R:Base table and do these steps: 1. UPDATE Invoice SET Flag = 1 WHERE InvDate = .#Date 2. PLUGIN RQBDataDirect.RBL vResult|ACTION Run |SCRIPT_FILE_NAME Invoices.RTF OUTPUT_FILE_NAME InvData.iif RETURN The script file would have the condition above. 3. UPDATE Invoice SET Flag = 0 WHERE Flag = 1 Is that correct? 2. Can I CHANGE the name of the export file so it doesn't keep overwriting? E.g., could I name my files InvDatammddyy.IIF where mmddyy is the month/day /year? Then build the PLUGIN command like this: SET VAR vPlugIn = ('PLUGIN RQBDataDirect.RBL vResult|ACTION Run |SCRIPT_FILE_NAME Invoices.RTF OUTPUT_FILE_NAME' & .vFileName & 'RETURN') &vPlugIn Is that possible? 3. I'm puzzled as to how you export invoice DETAIL to Quickbooks. I'm assuming that the list of tables in the documentation for RQBDataDirect is complete. I've carefully reviewed all fields in the TRNS table and see nothing for items on an invoice. I've carefully looked at all the tables: I see what appears to be the equivalent of an item master table, (INVITEM), but not a table that shows items for which a customer is being billed on an invoice. Has anyone done this and can you explain what I've missed? Is there ANOTHER Quickbooks table that will appear in the dropdown list that's not in the RQBDataDirect documentation? Thanks for your help! David Blocker [EMAIL PROTECTED] Telephone: 781-344-1920 Cell Phone: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, April 02, 2008 12:27 PM Subject: [RBASE-L] - Re: Confirm screen at closing form > At 12:12 PM 4/2/2008, Nico Hoencamp wrote: > >>I have a form attached to a dummy table which is called by EDIT USING. >>All changes to the database are handled by either LOAD, UPDATE or DELETE >> >>However, sometimes when the form will be closed I get a confirmation >>screen which asks: Save changes? >> >>I have 23 other forms which work the same and never show that screen. >> >>Does anyone know what to look for? > > Nico, > > Here's how: > > Use the following code as form "On After Start EEP". > > PROPERTY RBASE_FORM DONTSHOWSAVEDIALOG 'TRUE' > PROPERTY RBASE_FORM DONTSHOWDELETEDIALOG 'TRUE' > RETURN > > That's all there is to it! > > Very Best R:egards, > > Razzak. > > > > > > -- > No virus found in this incoming message. > Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.4/1355 - Release > Date: 4/1/2008 5:37 PM > >
