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!

Recent content by bharons

  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

    Good morning experts.. request correction 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...
  5. bharons

    filtering data with vfp 8

    can someone help me.. with my code because it wont show up data at my grid vfp 8.. below code that i use at my command button vfp 8 to filtering smalldatetime on sql server Local lcSQL, lcColumnname, lcValue1 lcColumnname1 = thisform.cmbKeyColumn.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

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

Part and Inventory Search

Back
Top