1. Steve Albin
  2. Valentina Database ADK
  3. Wednesday, May 18 2016, 08:34 PM
  4.  Subscribe via email
I have the following SQL:
SELECT   tblTypeExpenses.cTypeName,  tblExpenses.cProduct,  tblExpenses.cProductVendor,  FORMAT(tblExpenses.nExpenseAmount/100, '#,###.00', 'kNumberFormat'), 
tblExpenses.dExpenseBought , tblExpenses.RecId,
FORMAT(tblExpenses.dExpenseBought, 'YYYY-MM-dd', 'kDateFormat_Pattern')
FROM tblExpenses
INNER JOIN tblTypeExpenses ON Lnk_Expense_to_Type


tblExpenses.nExpenseAmount is a VULong field, but the VField.Type value being returned in the cursor is 24 - kTypeText. Is this because of the FORMAT expression? Is this the way it is supposed to work? I was hoping to have it return the value of the actual field, not the result of the expression.
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer
Hi,

Exactly, VText type is because of FORMAT sql-function which returns such a type. tblExpenses.nExpenseAmount is just an argument to this function.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories