1. Steve Albin
  2. Valentina Database ADK
  3. Mittwoch, Mai 18 2016, 08:34 PM
  4.  Abonnieren via E-Mail
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.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi,

Exactly, VText type is because of FORMAT sql-function which returns such a type. tblExpenses.nExpenseAmount is just an argument to this function.
Kommentar
There are no comments made yet.
  • Seite :
  • 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