Comments by mohammed mqi

mohammed mqi 23-Jun-20 21:38pm View

i know but how can i import it to my table in SQLite DB
What are the procedures for doing this and is there a sample for that?

mohammed mqi 1-Mar-20 10:12am View

i mean if you see after statement left
you will see i assign value to the rest columns

and a.[CreationDate]=GETDATE()--4
and a.[CreationTime]= CONVERT(time, GETDATE())--5
and a.active= 1--6
and a.Gruop=''--7

or this not work?!

mohammed mqi 1-Mar-20 10:02am View

so how can i add other column which no need to copy from that table

mohammed mqi 20-Feb-20 1:15am View

thanks for editing your answer

mohammed mqi 19-Feb-20 2:31am View

thanks Richard Deeming it's work perfectly that's great
also thanks Maciej Los

mohammed mqi 18-Feb-20 8:26am View

thanks it works fine but i have an issue if there's no dash"-" in my word it's give me error how can i avoid that?
also i try this and and also show me error for word doesn't contain dash

=IIf(InStr(Fields!Description.Value, "-") > 0,Left(Fields!Description.Value, InStr(Fields!Description.Value, "-")-1),Fields!Description.Value)

mohammed mqi 18-Feb-20 4:32am View

it's give me #Error

mohammed mqi 8-Dec-19 2:45am View

The expression of Textbox62 and Textbox61 actually come from total of tow different filtered table in body and it give expect value

mohammed mqi 17-Nov-19 1:48am View

it's work fine thanks so much MR.Richard

mohammed mqi 14-Nov-19 8:59am View

ok i got this error message
Object cannot be cast from DBNull to other types
System.DBNull.System.IConvertible.ToBoolean(IFormatProvider provider)

mohammed mqi 14-Nov-19 8:24am View

the problem is it's working fine with me but my friend pc not apply the stored procedure even not give me any error's i also enter same data

mohammed mqi 14-Nov-19 8:14am View

i have no error message but this funcation SelectedProcced won't apply on sql

mohammed mqi 7-Nov-18 9:05am View

thanks Richard for replay i'm using Convert.ToString to be more insure and becuase some time i revived float value
and about barcode equal to textBox1.Text becuase i'm using textBox1.Text for manual to put qty manul in other case after receiving barcode first then if qty empty it will be pass qty from textBox1.Text when switch case to inserting qty

mohammed mqi 7-Nov-18 7:32am View

it's give all correct result not reach to else statement at all with debugger only
and that what i want
but without debugger it's show me other result that's mean it's go to else statement

mohammed mqi 7-Nov-18 7:04am View

when i debug my code it's give me one result

mohammed mqi 7-Nov-18 6:58am View

thanks for helping
by the way i'm insert barcode manually
i remove all Exception but stil results changing every call
but when i debug my code it's give me one result

Comments by mohammed mqi (Top 16 by date)