Search results for query: *

dear Chriss my great lecturer..🥰🥰 this is my sampling sql server database in format excel..🙏 I use the coding below, to produce data that has the maximum value based on the criteria of the norekening column, the selisih column (number of days).. The question is whether the coding I used is...

well i try this code : lnResult = SQLExec(Thisform.nHandle, "select top (20) detail.norekening, detail.tanggal, jaminan.keterangan from dbo.detail join dbo.debitur on detail.norekening = debitur.norekening join dbo.jaminan on detail.norekening = jaminan.norekening where detail.tanggal =...

in second query i use this : lnResult = SQLExec(Thisform.nHandle, "select top (20) * from dbo.debitur join detailku on norekening = detailku.norekening", "debiturku") it is give me massage box that need to enter value for debiturku.cif (view parameter)..

good morning experts... Please correct my code below, because only one line of data appears: m.tanggal = thisform.txtTanggal.value lnResult = SQLExec(Thisform.nHandle, "select top (20) * from dbo.detail where tanggal = ?m.tanggal", "detailku") lnResult = SQLExec(Thisform.nHandle, "select top...

hay Chris.. my teacher.. :giggle: maybe all the problems that i got just in langguage barriers... 🤭.. but i will learn it any way..

It's complex with SQL Server. I only understand that VFP is probably only skin deep. So I hope that the experts will provide guidance to me, a newbie.. 🙏

With VFP I understand a little about CRUD commands, data manipulation, and now I am faced with an ODBC SQL Server based online system, I can be sure that I don't really understand CRUD SQL Server.

i write your code at my command button and i run it.. it is work like i want.. mket01 = Chrtran(transform(skedul1.norekening,"@R ###-##-####-####"),'-','.')

string? i add that value from sql server, with datatype decimal. and thank so much for info about maximum value.

I use this transform function..

After I tried changing the textbox in the report with transform(mket01,"999.99.9999.9999") and in the command button I still use the transform function(mket01,"999,99,9999,9999") Only then could I get the results I expected. My question is whether the coding I applied is right or wrong

After I tried changing the textbox in the report with transform(mket01,"999.99.9999.9999") and in the command button I still use the transform function(mket01,"999,99,9999,9999") Only then could I get the results I expected. My question is whether the coding I applied is right or wrong

that expression of "999.99.9999.9999" is register number, like the number above 1312124120052 becomes 131.21.2412.0052 After I expand the report column for that number, I still get an asterix, unless I use the transform function(@L,"999,99,9999,9999") can appear 131,21,2412,0052 looks...

after I created a cursor in vfp and filled it in with some data. I found a problem with the asterix value in my report. Is there something wrong with my writing format as mentioned below? create cursor skedul1 (norekening N(13), ke N(2), pokok_kr N(12), bunga_kr N(12), pokok_sd N(12)) insert...

Thank you for your attention... maybe next time you can provide other direction regarding the coding mistakes I made...

ohhh... i must reply those script until 4 time.. with condition no error on sql connect.. :unsure: :unsure:

Yupz... but its seem i can't get it.. where and when i must start scan also when i must ended with endscan.. 🙏

i use this script.. still have first row change.. 😞 select skedul1 m.value1 = skedul1.norekening m.value2 = skedul1.ke m.value3 = skedul1.pokok_kr m.value4 = skedul1.pokok_sd m.value5 = skedul1.bunga_kr lcSQL = 'update dbo.skedul SET pokok_kr = ?m.value3, pokok_sd = ?m.value4, bunga_kr =...

i try this script... but its seem i just only last row has changing...😞 select skedul1 scan m.value1 = skedul1.norekening m.value2 = skedul1.ke m.value3 = skedul1.pokok_kr m.value4 = skedul1.pokok_sd m.value5 = skedul1.bunga_kr TEXT TO m.lcSQL TEXTMERGE noshow UPDATE dbo.skedul...