User Profile

Collapse

Profile Sidebar

Collapse
Ifoel
Ifoel
Last Activity: Aug 14 '07, 06:03 AM
Joined: Jul 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Ifoel
    replied to Fetched the rows of the record MySQL
    Ok Killer42...
    this very help full

    thanks again...
    See more | Go to post

    Leave a comment:


  • Ifoel
    started a topic Fetched the rows of the record MySQL

    Fetched the rows of the record MySQL

    Hi all
    pls help me

    How to know "HOW MANY SECOND" we fetched the rows of the record MySQL via Visual Basic 6...?

    Sample:
    321 rows Fetched in 0,234s -> i need this field to load on the FORM VB

    thanks in advance
    See more | Go to post

  • Ifoel
    started a topic Convert date format

    Convert date format

    Hai All,

    Im beginer in Mysql.
    I have field's Date in MySql, with format "dd/mm/yyyy hh:mm:ss".
    How the syntax Select it and format change like this "yyyy-mm-dd hh:mm:ss"?



    Date
    04/07/2007 21:23:37

    Change to

    Date
    2007-07-04 21:23:37

    how to works

    thanks in advance
    See more | Go to post

  • Ifoel
    replied to Convert date format
    Oke Hari..
    I dont mean it..

    thanks for your reply
    See more | Go to post

    Leave a comment:


  • Ifoel
    started a topic Convert date format

    Convert date format

    Hai All,

    Im beginer in Mysql.
    I have field's Date in MySql, with format "dd/mm/yyyy hh:mm:ss".
    How to Select it and format change like this "yyyy-mm-dd hh:mm:ss"?



    Date
    04/07/2007 21:23:37

    Change to

    Date
    2007-07-04 21:23:37

    how to works

    thanks in advance
    See more | Go to post

  • Ifoel
    started a topic Convert date format

    Convert date format

    Hai All

    Im beginer in Mysql.
    I have field Date in MySql, with format "dd/mm/yyyy hh:mm:ss".
    How to Select it and format change like this "yyyy-mm-dd hh:mm:ss"?



    Date
    04/07/2007 21:23:37

    Change to

    Date
    2007-07-04 21:23:37

    how to works

    thanks in advance
    See more | Go to post

  • sorry hariharanmca..
    not work
    when looping run the resul text1.text =1
    just it... and stop and looping not run again even check1 value =1
    See more | Go to post

    Leave a comment:


  • Yes Killer42...u r correct..
    i have put code like
    still not work

    [CODE=vb]Private Sub Timer1_Timer()
    If Check1.Value = 1 Then
    For j = 100 To 10000
    DoEvents
    Text1.Text = j
    Next j
    End if
    End Sub[/CODE]

    so whould u give me some code Killer42
    to stop loop when i checked=0.

    thanks in adva...
    See more | Go to post

    Leave a comment:


  • Ok thanks Hariharanmca...
    I just want make programm like LOTTRE do u know LOTTRE.. ..mmm to defficult to say...cos my english so poor...

    I just 1 winning or 1 value in text1.text from looping run, not all number from 100 to 10000 display on text1.tex.

    when i click check box value= 1 then looping on, If check1 box = 0 looping off

    this sample:

    Private Sub Check1_Click()
    ...
    See more | Go to post

    Leave a comment:


  • Hi Hariharanmca
    thanks for u reply...
    My original code has corect, like Killer42 said. I just add DoEvents in loop.
    now i get trouble, when i click check box for stop looping, why looping still running. and value of Text1.text always 10000.
    i have put code when value check1 box = 0, timer1.enable=f alse.
    why this haven?. how to directly stop looping when timer1 false?
    so i can get value on text1.text like...
    See more | Go to post

    Leave a comment:


  • thanks alot for all

    Thanks alot Killer42 and Hariharanmca... ........
    this very help full
    .....
    See more | Go to post
    Last edited by Ifoel; Jul 13 '07, 02:28 AM. Reason: i want thanks to all participants

    Leave a comment:


  • Ifoel
    started a topic Looping character or number visual basic 6

    Looping character or number visual basic 6

    Hi all,
    Sorry im beginer in vb.
    I want making programm looping character or number.
    Just say i have numbers from 100 to 10000.

    just sample:

    Private Sub Timer1_Timer()

    if check1.value= 1 then
    for i = 100 to 10000
    text1.text= i
    next i
    end if

    end sub

    but this looping not like i wanted,

    I want all number...
    See more | Go to post
No activity results to display
Show More
Working...