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 strongm 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: *

  • Users: bharons
  • Content: Threads
  • Order by date
  1. 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...
  2. bharons

    a little confused about the transform() function problem

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

    Update Data SQL server Using Create Cursor VFP

    Dear Expert...:giggle::giggle: I use VFP8 for SQL Server data processing, I have a question, how to code or script to update data in SQL Server using Create Cursor VFP. For example, below is the script that I use. create cursor skedul1 (norekening N(13), ke N(2), pokok_kr N(12), bunga_kr...
  4. bharons

    function argument value, type or count is invalid

    dear expert.. i have some value on sql server with data type decimals, when i use this statement on vfp 8 thisform.text3.value = subs(val(thisform.txtvalue),4,2) or thisform.text3.value = subs(tranform(thisform.txtvalue),4,2) both text3 or txtvalue with value property are none i got massage that...
  5. bharons

    Pick up value from combobox

    hello experts... I have a combobox containing data which is a column of a table. So far I have used code like this: Public column_name, column_name1, column_name2, column_name3, column_name4, ; column_name5, column_name6, column_name7, column_name8, column_name9 if...
  6. bharons

    The conversion of the varchar value '1111224080294' overflowed an int column

    Dear Expert.. I don't know if I post this question in the VFP forum or the SQl Server forum. because I use vfp 8 with Sql Database back end, so I asked in this forum... I have code like this below: local lcValue, lcValue1 lcValue = thisform.text1.value && No Pengajuan lcValue1 =...
  7. bharons

    Find the location of the column in the VFP table

    Dear Expert.. I have a classic question. and I don't understand how to solve it, namely looking for a column where the contents of that column are exactly the same as the VFP textbox. The following is the coding that I use. select crsResult3 lcVar = thisform.text1.value for lnColumn = 1 to...
  8. bharons

    selected value from grid to another grid

    Hey experts, it seems my question is classic. I have code like below. select * from crsresult where alltrim(thisform.text1.value) = thisform.text2.value into cursor 'crsResult1' where textbox1 and textbox2 come from the afterrowcolchange grid, ie LPARAMETERS nColIndex thisform.text1.value...
  9. bharons

    handle column count Grid on VFP

    Another question based on update data table sql, i have a grid1 based on combobox vfp and textbox. Actually i taken this script or code from Mr. Cetin with his permission..[wink], like below. Local lcSQL Use In (Select('crsResult')) TEXT TO m.lcSQL TEXTMERGE noshow...
  10. bharons

    update data table sql server using form vfp

    hay.. i wanna ask something, are my script is right to execute to update data on table sql server using vfp 8 on load form vfp public KONEKSI, mskedul1 STORE SQLCONNECT('dana','dana','dana_database') TO KONEKSI IF KONEKSI > 0 SQLEXEC(KONEKSI,'use ksp_arthadana') endif...
  11. bharons

    create main.prg on app vfp9

    hay expert?? i am newer on this forum? i want to create app that main databases locate in server? and my main server is '\\ACCOUNTING\smartksp\DATA\30\data'? in my main prg just like my attachment? so far when i call a program that i choose is running well, but when i want a copy apart of...

Part and Inventory Search

Back
Top