select substr(ss_id, -6) from id_table
this should work for you
if i am being punished for being in love , i a m ready to die,
"Who do you turn to when the only person in the world that can stop you from crying, is exactly the one making you." cry?
1. select the month. 2. findout all the dates. 3. findout the days by passing the dates ---use WEEKDAYNAME function for the purpose.
you want me to write a complete accounts package in VB 6.0 and give it to you for free ?
select all records from temp table into recordset.
insert to temp2 table in a loop and finally commit.
Love is like a river, always changing, but always finding you again somewhere down the road.--------- Kelly Elaine
is that in VB 6.0 ?
and just to explain
vbcrlf----stands for---VisualBasicCarriageReturnLineFeed.
even though a bit long, i hope that is quiet easy to undestand .
1.i can't understand the first question.
2.if you are looking for the connection string find it here.
what do you mean by only distinct row .
i believe that means all the fields in a row are same.
distinct will definately filter that out.
what is My ?
is that an object ?
you can use recordset for the purpose.
open a recordset from temp table and insert to temp2 table. later if you want to delete the records from temp then go for it.
looked
wife I would like----you may not like.
-1113
you deserve a pat on the back. so pat pat pat.......pat pat pat ....pat pat pat .... i hope that is enough
why not run the exe by using Scheduled Task ...
even better to use any grid control.
Love is most nearly itself When here and now cease to matter.---- T.S. Eliot
Love looks not with the eyes but with the mind. -----William Shakespeare in A Midsummer Night's Dream (I, i, 234)
what exactly is a fade in and fade out label ?
try to use some flag setting for loading and unloading of child forms and check the same during unload of the MDI form.
was
awesome program --> i am an awesome programmer
934
what about using flexgrid ? or any other grid control.
kindly post the codde that you are working on, and the part you are faing problem in.
why you need to connect Vb to another GUI tool , not a database.
I hope yo know SQLyog is a GUI not a database like msaccess.
if you are looking for the connection string to mysql ,find it here.
then you need to findout the time difference between the start time and end time and keep on adding them
that is not possible (to reverse engineer the EXE to get the source code).
if you want to use database then definately yo can use sql ,pl/sql but not for designing the page.
Let no one who loves be called altogether unhappy; even love unreturned has its rainbow.
select * from dept where d_name in (select d_name from dept group by d_name having count(d_name)>1 )
what is the table structure and what is the query that you are working on ?
oracle does not support the data type BOOLEAN in sql.
use some flag for true and false and process accordingly.
PL/SQL is not desinged to create web pages. you need to use some scripting language for that.
you simply need to use TO_CHAR for the purpose and convert the sysdate to desired format.
else if you want to run the program without installation (in the same system) ,you can simple compile an EXE from file menu---->Make exe.
What do you mean by compiler for VB6 ?
If you want the VisualStudio, that is not supported any more by MS so VB6.0 is not available for purchasing anymore .
what is the problem for you ?
i suggest you to better use DTPicker control instead of a calander.
What is love but that which poisons the body, clouds the mind, yet envigorates the soul.
is that for interface of VB applications ?
You need to design your own compoent for that.
Wishing Happy New year to my immediate neighbours, a bit in advance though.
scram
-1107
790
Wishing the best ever happy new year to all at daniweb.
Love is Love; if it feels like love, then no doubt it is love. Simple.
