Search results for query: *

Thanks for your reply...vongrunt and also thanks to tc3596.. TC3596 :- I am using MsAccess on the backend side..so i can't really use store procedure concept... Vongrunt...i think your code really helps for me... I will try to implement and i will let you know how i did... Thanks SQLDev

Thanks for your reply... I just want to do update no Insert.... All the custLifeNo and weekNo are even in WLDenormalized and tblWLEmpType_WLDay table... So...could you give me update sql or logic...to achieve this task... Thanks SQLDEv

Hello Everyone.. I have ask this question to many SQL Developer but nobody had given me better answer... On my form i have button save/upload History when user clicks on it, I want to save the data from WLCust_Denormalized to WLCustAct_Emp table... How would i save the data from...

Hello Donutman I have ask this question to many SQL Developer but nobody had given me better answer... If you remember me you help me to write sql to insert data from Denormalized table to Normalized table... Now I in my project i have to go reverse...Another words... On my form i have...

again thx I have IIS Server Install on my machine...I am trying to browse" via a right click of the website within the IIS manager....and and it says page can't display... I have tried to reinstall the iis also that doesn't work either... I am not running URL Scan... There is no red dots on...

Thanks for your reply Let me give you more in detail... I am trying to open ASP or html pages from IIS After i install IIS I open the IIS and went into Website --> Default website folder and i am trying to open Anyfiles (life iisstart.asp,localstart.asp with Internate Browser it says page...

Hello Guys I am new with IIS.. I have installed IIS on My machine Operating System : Windows XP Professinal IIS Server is running and now i when i try to write open from browser http://localhost i have error paga cannot be displyed... Is anyone knows how to resolve this situation. Thanks AD

I am running this code from VB front end and all the tables i am using they are all local Ms Access tables.. So, I guess that's the reason.. AD

Hello Everyone I have allready post this question on VB Forum but didn't get any response...... I have a VB program that calls a DTS package to import data from a text file into a database for reporting. The DTS package works wonderfully. The problem I'm running into though is creating an...

Hello Everyone I have a VB program that calls a DTS package to import data from a text file into a database for reporting. The DTS package works wonderfully. The problem I'm running into though is creating an installer for my app with the right DTS files. I'm using VB 6 and the DTS packages...

if you see my above code... I have sign says -->> Error on that line i am getting an error. also you said before "After you append the column to the columns collection, but before you append the table to the database, set the Properties of the column as desired:" I have tryed both ways but i...

Now I have " run time error 2147217887 Multiple step Oleddb operation generated errors check Oledb status value, If available. No work was done" Here is my code... please help me out.. I can't figure out what's wrong with this code.. Dim wk_Catalog As ADOX.Catalog Dim LocalDb As...

Following function create a table on MS Access Name WLMod_Denormalized... every thing works fine but now i want to change one property: How do i set all column names property called required = NO In short in this table required data entry = NO by default it creates a field with require data...

I want to run following query in command click event VB 6.0 support only 25 physical lines lines joined with line-continuation... so is there anybody can help me out...that how and where should i write this sql to execute... any help would really appriciate.. INSERT INTO...

Thank you so much...It's working fine.. It's taking little bit long...so if that's the only way we have to do then it's ok... if you have more suggesion to imporve perfomance..let me know.. In my case I am executing this query on command click event of VB... In short when user dowload some...

I am going to complete whole query and i will let you know today... Thanks...Thanks....Thanks.... AD

denormalized table - New table which doesn't have any records... but let say if i insert manually above record (table Name :WLCustAct_Emp - CustLifeNo=330374 ) to denormalized table...It should look like this... Table Name : WLCustAct_Emp Structure and data CustLifeNo WLActCatId WLDayId...

Thanks for your concern...donutman.. Please help me out when you get a chance.. From my side i will keep trying... Thx AD

Now I am getting an error Incorrect syntex near case please help me on this... F.Y.I. - > I had to change table names an field names as my manager requested... UPDATE Test_Denormalized case when WLActEmp.WLActCatId = 'M' And WLActEmp.WLDayId = 'MON' Then SET...

Donutman... Thanks for your reply... Let me try and i will let you know.. Thx ad