Comments by Rabee Qabaha

Rabee Qabaha 28-Apr-21 19:22pm View

Hello @Gerry,
So what you are saying that I need to create a new table called Invoices, all payments for both yearly and monthly should be stored in this table.
but what about the monthly payments, what the best way to deal with that?? generate a new table contains all the monthly payments??

Rabee Qabaha 17-Mar-21 16:23pm View

I did as you said but I'm getting this error: "near "BY": syntax error" here is the query now :

SELECT ROW_NUMBER() OVER (ORDER BY
(SELECT 1)) num_col, ID, cust_id, final, value, date, sum(balance) PARTITION BY (partition BY cust_id
ORDER BY date, seq, ID) balance, note
FROM (SELECT ID, cust_id, final, 0, final balance, date, note, 0
FROM transfers UNION ALL
SELECT ID, cust_id, 0, value, - value, date, note, 1
FROM trans_payments) t (ID, cust_id, final, value, balance, date, note, seq)
ORDER BY cust_id, date, seq

Rabee Qabaha 17-Mar-21 8:32am View

I have an error on Top I know it's limit in SQLite, I'm getting also an error on (SELEC 1)) num_col, I tried a lot But I couldn't convert it I'm new to SQLite

Rabee Qabaha 16-Nov-17 7:58am View

Thank you man , i solved the problem, appreciate your effort.

Rabee Qabaha 25-Jan-17 18:13pm View

@Member 9831003 Hello until now i couldn't fiend a solution, can you help me ??
please show me how to do this in code

Rabee Qabaha 23-Jan-17 10:12am View

Yes the date field is Datetime so do i need cast ??
or just use your code ??

Rabee Qabaha 22-Jan-17 11:06am View

I tried but I couldn't make it, thank you

Rabee Qabaha 22-Jan-17 10:48am View

I tried but i couldn't can you show me how please

Rabee Qabaha 9-Dec-16 20:35pm View

this is C# and I'm not good in it, can you give me a sample example pleas??
thank you

Rabee Qabaha 9-Dec-16 20:33pm View

i have class for connection, i don't need to add the connection more than one time

Rabee Qabaha 16-Oct-16 19:26pm View

thank you for replay, then what i can do ??
can you help please ?

Rabee Qabaha 16-Oct-16 10:49am View

I solved the problem by the bellow code, is it the right way to do it ??

Rabee Qabaha 16-Oct-16 8:24am View

I did That but i couldn't call the value from the property :(
i will show you the code in the qustion.

Rabee Qabaha 15-Oct-16 22:11pm View

I don't know , this code just to pass post question.
is there solution to my question ??

Rabee Qabaha 20-Sep-16 10:12am View

what you want man ??
are you trying to help, or you trying to make fight??
my question clear as the sun in the middle of day !!
you don't even need the code to help
all what I asked for is how can i call method from usercontrol in main form?
or this is because I'm Arabic ??
so I'll give you infinity break my friend i don't want your help thank you
and have a nice day.

Rabee Qabaha 19-Sep-16 17:27pm View

my problem is I cant call the method in my main form because it's in the user-control normally i can call any method from other forms but from the usercontrol its different , so how can I call it is there any way to call it from the form, i seen that way by make event but i couldn't make it?

Rabee Qabaha 19-Sep-16 15:35pm View

what im doing is using user-control in form with menu, i want to call the method FillGrid() from usercontrol"Send_Money" in my Main form so i can fill the datagridview "MetroGrid2" when i press the button in My Main form.

Rabee Qabaha 17-Sep-16 16:51pm View

@Karthik Bangalore
then how can i do it in my case.
all what i want that the client can leave empty value
then update the data.

Rabee Qabaha 2-Sep-16 14:51pm View

ok thank you man, i will try again

Rabee Qabaha 2-Sep-16 14:28pm View

hello OriginalGriff thanks for this detailed answer, actually I know where the error come, it comes from the showLV method ( method to get data from sql server to show it in the listview)
and if i removed this method everything work fine, the question is how to make this code to avoid return null value .
thanks you

Comments by Rabee Qabaha (Top 20 by date)