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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
populating SQL table from Great Plains Window Data
Here is what I am trying to do. It is giving me a syntax error in the objRs.Open portion. objCmd.CommandText = "INSERT INTO RinVoucherPO (VoucherNum, PONum1, PONum2, PONum3, PONum4, AMT, AMT1, AMT2, AMT3 )" & _ " SELECT (VoucherNo, PONumber, PONum1, PONum2, PONum3, AMT...- lbanks1
- Post #5
- Forum: Microsoft: Dynamics GP (Great Plains)
-
populating SQL table from Great Plains Window Data
I have not used DUOS before. I need to get this done today as I am changing positions to another company. Can you give me some solid insight on how to quickly set this up using DUOS?- lbanks1
- Post #4
- Forum: Microsoft: Dynamics GP (Great Plains)
-
populating SQL table from Great Plains Window Data
I have a table that I created using Enterprise Manager. I want to use this on the Save Button: Insert Into table name (field names in table) Select (fields) from open Window How do I reference the window? I have tried window.windowname.field, me.windowname.field, me.field and nothing is...- lbanks1
- Thread
- Replies: 4
- Forum: Microsoft: Dynamics GP (Great Plains)
