How To Implement Microsoft Adds In Universal Windows Platfo

Question

I Want Adds In Universal Windows Platform project and .I Added UniversalWindows10_Framework To The Project.I don't konw how to implement Microsoft adds in that project.Can Anyone Give Me The Documentation For Implementing Adds In Universal windows platform project.

 

Thanks In Advance. 

Answer 1

Correct sSql string is follows..
sSQL = "Insert into Transaction_Line (TransL_id,Trans_id, TL_dt, Pro_id, Quantity)" & _
"values('" & TransLid & "', '" & transID & "', '" & TLdte & "', '" & proID & "', '" & quan & "')"

Change transID Position in values it will be in 2nd position.
 

Answer 2

hi

i think you have taken date field value int not datetime or varchar . That's why you are getting this error.

please change it to datetime.

Don't forget to Mark Do you like this Answer  that solved your problem!

Answer 3

TransL_id: Varchar(25)
Trans_id: int
Pro_id: Varchar(15)
Quantity: numeric(4, 0)
Total_price: numeric(10, 2)
TL_dt: varchar(50)
Share_h_id: varchar(10)

For the TL_dt  tried a dateandtime format but its not working at all it always retrieves an error... therefore i tried the varchar instead

Answer 4

Hi,
The error is  coming due to this sentence,
sSQL = "Insert into Transaction_Line (TransL_id,Trans_id, TL_dt, Pro_id, Quantity)" & _
"values('" & TransLid & "', '" & TLdte & "', '" & proID & "', '" & quan & "', '" & transID & "')"
 
In that u r trying to insert..
TransL_id (int)- > TransLid (int),
Trans_id (int) - > TLdte (date),
TL_dt (date) -> proID (int),
Pro_id - > quan ,
Quantity - > transID

Answer 5

Can you also post Transaction_Line table structure (Fields with DataType) ?