Exclusively for Visual Basic 6.0 Programmers Only!

[patrickkillua]

Hi.. question lng guys.. Newbie lng sa mysql.
may stored procedure na kasi akong ganito pag build ng statement
SET @sql=CONCAT("select ", _Columns,",RecordID,FileCount,FileName,FilePath,Comment,UpdateDate,FileType,CreateDate,fn_getAudioFilename2(JobID,",v_ProjectID,") as AudioFileName FROM ",_tableName , " ", _filter,v_Sort );



SET @sql=CONCAT("select JobID,MRNumber,LastName,FirstName,DOB,DOS,Dictator,WT,Status,Priority,Dictation_Date,Concat(MRNumber,',',JobID,',',FirstName,',',LastName) AS RecordTittle,RecordID,FileCount,FileName,
FilePath,Comment,UpdateDate,FileType,CreateDate,COALESCE(Nullif(B.AudioFileName,''),'NOAUDIO') as AudioFileName FROM " ,_tableName,
" A,(select PrimaryJobID,AudioFileName,ProjectID,mp3flag from tbl_audiofiles) B ", _filter ," and substring_index(A.jobID,'-',1) = B.PrimaryJobID and ProjectID=47 and mp3flag=1 " , v_Sort);



Tanong ko lng dito kung working po ba ung mga joing inside Sp ni mysql??
working naman but once na nag karoon na ko ng Joining ayaw na nya gumana .. Gamit ko po ngaun mysql workbench 5.2.44CE

 

[cjxians]

henge po ako ng installer po.. plsss.

 

[dennis20]

mga sir at maam , here is my situation

i inserted a browser in my windows application form. it works well with other websites such as google and even google maps,
but my specific site of interest is to integrate http://faultfinder.phivolcs.dost.gov.ph/ in my application.
how do you think i can do this, thanks in advance.

i have tried changing the value of script error suppressed but it doesnt solve my problem
the error i keep on having is
object doesn't support this property or method addeventlistener
aand

unable to set property 0 of undefined or null reference

thank you

 

[jess1993]

Hi.. question lng guys.. Newbie lng sa mysql.
may stored procedure na kasi akong ganito pag build ng statement
SET @sql=CONCAT("select ", _Columns,",RecordID,FileCount,FileName,FilePath,Comment,UpdateDate,FileType,CreateDate,fn_getAudioFilename2(JobID,",v_ProjectID,") as AudioFileName FROM ",_tableName , " ", _filter,v_Sort );



SET @sql=CONCAT("select JobID,MRNumber,LastName,FirstName,DOB,DOS,Dictator,WT,Status,Priority,Dictation_Date,Concat(MRNumber,',',JobID,',',FirstName,',',LastName) AS RecordTittle,RecordID,FileCount,FileName,
FilePath,Comment,UpdateDate,FileType,CreateDate,COALESCE(Nullif(B.AudioFileName,''),'NOAUDIO') as AudioFileName FROM " ,_tableName,
" A,(select PrimaryJobID,AudioFileName,ProjectID,mp3flag from tbl_audiofiles) B ", _filter ," and substring_index(A.jobID,'-',1) = B.PrimaryJobID and ProjectID=47 and mp3flag=1 " , v_Sort);



Tanong ko lng dito kung working po ba ung mga joing inside Sp ni mysql??
working naman but once na nag karoon na ko ng Joining ayaw na nya gumana .. Gamit ko po ngaun mysql workbench 5.2.44CE

yes.. working po sa stored procedure ang JOINING, if hindi siya gumagana then check your actual query if may result ba talaga..
base sa code mo, save mo si @sql to table then select mo si table and try to run the saved script.

 

[virch]

Sir ask lng ako meron po ba kayo idea pag biometric nang isang tao send agad thru sms kung anung time sya pumasok patulong naman sir kung pano gawin salamat po

 

[balon99]

Goodmorning guys.. pahelp po ako about sa "Multiple Search". halimbawa sa isang field masearch nia any letters. thanks..sana mahelp nio ako

 

[shadow046]

pwede pong makahingi ng tulong? need ko po sana ng syntax para dito...

Plus lang. Quantity

Example
Cellphone
Qty
10.

Then bumili ako ulit ng
5 so. Total 15 na.
Then may bumili 6.
Total 9 na lang

sabaw na utak ko T_T

 

[kagidka]

pwede pong makahingi ng tulong? need ko po sana ng syntax para dito...

Plus lang. Quantity

Example
Cellphone
Qty
10.

Then bumili ako ulit ng
5 so. Total 15 na.
Then may bumili 6.
Total 9 na lang

sabaw na utak ko T_T

kung gusto mo layout mona sa excel mag pivotable ka. walang computation mang yayari sa data mo. kapain mo sa status if 1 meaning available sya pag 0 nabintaa na. sa view mo lng eh computer ilang yung 1 at ilang yung 0 yan eh subtract mo

 

[eheems]

Beginner here.
Seeking o Suggest po sana kayo ng mga features na nakapaloob sa isang Library System using Visual Basic 6.0 ?
If may source code po , mas okay po . pero kung wala , okay lang din naman.
Sa ngaun kasi self-exploration e .
Di naturo ng maayos ng prof gawa ng pala absent yung prof tapos biglang pathesis -_-
Any suggestion o comment po ay welcome.
Maraming Salamat sa thread nato !

 

[zurikakino]

Re: Exclusive for Visual Basic 6.0 Programmers Only!

thanks idol

- - - Updated - - -

ako dn pa Tambay

 

[thmstugs30]

baka meron yang simpleng inventory system ung naka connect na sa access. salamat

 

[gamechanger7890]

baka meron yang simpleng inventory system ung naka connect na sa access. salamat

Yung parang ganito Simple Inventory Program ? Pwede ka na siguro magstart diyan.

 

[kiel enzo]

pa help naman mga idol need ko kasi ng tools withdraw and return system.. baka po matutulungan niyo ako vb6.0 po

 

[opow]

Patambay po dito. ��

- - - Updated - - -

Patambay po dito.

 

[kenzo04]

sir pahingi nman Installer Visual Basic, Salamat in Advance

 

[mmdeguzman]

Pa help po. Regarding in visual basic 6.0
Compile error : method or data member not found pano po i fix ?
Thanks po in advance

 

[NIJ14]

Pa help po. Regarding in visual basic 6.0
Compile error : method or data member not found pano po i fix ?
Thanks po in advance

Kulang ang mga components niyan.

 

[skyhack31]

Hi mga programmers. Pasubscribed lang po. Salamat!

 

[aJdeveyrA]

meron po bang source code ng Library Management System tnx po sa magshishare

 

[hardcorekid03]

ako meron kaso di ko na natapos ehh

- - - Updated - - -

meron po bang source code ng Library Management System tnx po sa magshishare

ako meron kaso di ko na natapos