Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bharons

    T-SQL in vfp 8 to find same value

    whoops.. sorry that is one account.. I will give you several accounts with a certain amount of activity.. 🙏 🙏
  2. bharons

    T-SQL in vfp 8 to find same value

    one more question, I get all the records from your coding, the problem is why all the records appear if the difference and difference2 have a value of 0 (zero). and can I get 1 row from the difference and difference2 with a value of 0 (zero)
  3. bharons

    T-SQL in vfp 8 to find same value

    thanks Mr. Gibbs.. above your code i implement to my form.. and give me the answer that i want.. 🥰 🥰
  4. bharons

    T-SQL in vfp 8 to find same value

    ...for the T-sql coding error below. it is give me notification that windowed function can be use in select and order clause. Local lcSQL1, lcSQL2 *norekening = crsSampleData.norekening norekening = 1111125010021 TEXT TO m.lcSQL1 noshow create table zonaku (norekening decimal(14), date1...
  5. bharons

    filtering data with vfp 8

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

    SQL Server data processing with VFP 8

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

    SQL Server data processing with VFP 8

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

    SQL Server data processing with VFP 8

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

    SQL Server data processing with VFP 8

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

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

    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.. 🙏
  12. bharons

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

    I use this transform function..
  16. bharons

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

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

    a little confused about the transform() function problem

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

    Update Data SQL server Using Create Cursor VFP

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

Part and Inventory Search

Back
Top