Search results for query: *

...my command button vfp 8 to filtering smalldatetime on sql server Local lcSQL, lcColumnname, lcValue1 lcColumnname1 = thisform.cmbKeyColumn.value *lcValue1 = date(year(thisform.txtTanggal.value),month(thisform.txtTanggal.value),day(thisform.txtTanggal.value)) *lcValue1 =...

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)..

...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 (20) * from dbo.debitur where...

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...

...= transform(skedul1.bunga_kr,"999.999.999.999") REPORT FORM "E:\My Foxy\Vfp8\Report\myslip.frx" PREVIEW report gives me an asterisk for mket01 = ***.**.****.**** Meanwhile for mket02 to mket 05 there are no problems. Are there really any problems in writing my coding? I'm using VFP 8...

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 =...