Search results for query: *

Hi guys, I used to work with SP's since few months, but I would like to improve myself with SQL Server Managment Studio 2005. Do you know guys tips about how to debug SP's with this tool? I mean something that you use when this is needed or maybe a good tip that you find on this tool that you...

Hi Guys, I used to work with VB 6.0 but now for work reasons we need to use VB .Net 2005 or 2008. Some people told me that .Net is very different that the VB 6 Version and I would like to find a very good training course in order to lear this 2005 or 2008 version. Do you know guys about a...

Hi Guys, I almost finish an application but I missing the last part, maybe you can give me some suggestions about how to do this thing: My application creates a File on my Local Directory (For example... C:\Myfile.txt) I need to send this file to another server by FTP Conection. For example...

Hi Guys, I almost got it but I decided your opinion on this: I have a String Variable called "MyFileName" and I Would like to concatenate with date and Time, Example: MyFileName = MyFileName & "_" & Year(Date) & "_" & Month(Date) & "_" & Day(Date) With this I have two questions: 1 - It...

Hi guys, I would like to have suggestions about how to do this thing: I have two tables: HeaderTable: Index field1 (InvoiceNo) field2 (InvoiceDescription) DetailTable Index Field1 (ItemCode) Field2 (Item Description) it Can be only one header and "N" details For example: InvoiceNo...

Hi guys, Do you know if it is possible to do this on XML? somebody told me to verify this option. I have two tables: HeaderTable: Index field1 (InvoiceNo) field2 (InvoiceDescription) DetailTable Index Field1 (ItemCode) Field2 (Item Description) Can be one header and "N" details For...

Hi bborissov, I'm new in XML, what do you think? Will be easier? if yes how can I start about trying with XML for this issue? I was thinking in the programming by XML looks interesting... Regards!

Thanks TheSQL I will check the Programming option... Regards!

Thanks TheSql, I think with an example will be a better and understable view... HeaderTable: Index field1 (InvoiceNo) field2 (InvoiceDescription) DetailTable Index Field1 (ItemCode) Field2 (Item Description) Can be one header and "N" details For example: InvoiceNo: 1000...

Thanks, for example I have this table Created: TableHeader: HeaderField1 HeaderField2 HeaderField3 DetailTable: DetailField1 DetailField2 DetailField3 DetailField4 And I need to convert this SQL Tables on this Delimiter Text File...

Hi Guys, I Need Ideas about have to build this issue, maybe you got good sugestions... The thing is that I need to create a File using Pipes "|" delimiters, for example like this: CFD|2.0||5847|012345678901234567890|4598|2007|ABC|A|1|20/09/2007|15:12:03| First I thought in create a SQL Table...

Hi Guys, It works! Thanks!

Hi Guys, Do you know how can I do this in classic Select? I have a field in my table that has negative values and positive values, for example: -1 -4 5 6 343 -34 I need just to put this in my select: Select MyField From MyTable But MyField if the value is positive to put "Positive" and if...

Hi Guys, I'm using a ListBox Control on Visual Fox Pro 6.0 Does anyone knows how can I use this control to count the records that I have in the ListBox? Recordcount? ItemIndex? Thanks for any help <MR>

Hi Sunila, Thanks for the information, I think this is what I need... just when I tried to put the BCP in my SP on SQL 9.0 Version it doesn't recognize this command... did you use it before? Thanks! MR

Hi Guys! I have this situation, I need to create a flat file from a SQL table that I got, but I don't know how to do it inside an SP... I tried with DTS and it Works good.... The thing is that I need to do it in a SP and not on DTS, I tried to find the DTS code in order to put it on a SP but...

Hi Guys, Does anyone knows which command can I use in order to get the date from another PC or Server in Visual Basic 6? For example, I put the time of my PC in this variable: MyVar = Time But I would like to take it from another PC? MyVar = A_Server_Time (or another_PC_Time) This server...

Hi! Does anyone knows how can I print in Visual FoxPro 6.0 in a Collate Way? For Example: I got 3 records : Record1 Record2 Record3 If I use this Visual FoxPro 6 Command: REPORT FORM File.FRX TO PRINTER NOCONSOLE It is going to print 1 by page. How can I print 2 copies and have this way...

Hi Guys ! Does anyone recommend me a good tool (software) where I can control my Inventory Hardware and software? thanks for any suggestions MR

Hey Guys, You are really good this is what I needed.. Thanks a lot !!! MenyR