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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VB6 program Unable to update Order Entry unit price field
Hi All, I am using VB6 to import order entry from SQL to Accpac pervasive. Other fields come in ok, say, item number, qty. Only, unit price, I cannot make it to come in from SQL. I have tried all kinds of data type for the field, CStr, CDec, CDbl, none of them worked. Sample line of code...- proxy00
- Thread
- Replies: 6
- Forum: ACCPAC Solutions
-
Invalid Signon Information - Accpac Web Development .Net
Hello, I am new in Accpac API web development area. I followed the sample to create a very simple .net web to write new order entry to Accpac Pervasive DB. I am using Accpac 5.4a with all service packs and MS studio .NET v2002. My development environment is Windows XP. I stuck on the first...- proxy00
- Thread
- Replies: 1
- Forum: ACCPAC Solutions
-
SQL, Looking back several months data for a specific row data
Hello, Could anyone help me on writing a SQL statement to get the following data? Originally, I have a data set: Key | Period | rowValue 1 | 2003/01 | 5 2 | 2003/02 | 8 3 | 2003/03 | 20 4 | 2003/04 | 10 5 | 2003/05 | 7 ... And want to have a desired dataset: Key |...
