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 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, 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 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

Hi Guys! Does anyone knows how I can make a delete of this kind? For example, I have 3 records like this: NAME VERSION AA 3 AA 2 AA 4 I need only the last version of this group, example: NAME VERSION AA 4 But the thing here is, that I need to delete the others records from my...

Hi Guys! I got a question, I have this string "A3232 4566 2323" And I would like to convert it into this: "A323245662323" To take out the spaces of it with a Function, is there a trim function or do I have to create a funcion by my self? Thanks for any suggestions! Meny

Hi Guys, Here, all of us when we would like to manage tables instead of use SQL Entreprise Manager or Query Analizer sometimes we use Access (Linking tables by SQL). This is because sometimes is more easy to work with this tables (Filtering, ordering, copying this data to excel very simple...

Hi guys! Just to know, is there any way I can run a program and then this stop to start debugin when an expresion is true?? For example reading a lot or records but I only would like to review (step on) when my Variable containg a value? (for example MYVAR = "AABB") This can make me...

Hi! Does anyone has used this command to open an ODBC source?? This is because my source is not Access of Fox or SQL, is a OpenVMS (connx or EasySoft) source. In Windows ODBC I can do the conection very well, but how can I use this command to check if I can open it in a SP? Thanks for any...

Hi Guys, I got a question with SQL Reporting Services. Is there a possibility (before running a report) to check one field in a table with a condition in order to specify to continue running a report? For example, I run my report, then this one check a table with a field called Not_Run="Y"...

Hi Guys, This is a simple question: I already finished some reports with this great SQL Reporting Tool (Visual Studio 2003) and I don't know how can I put a visible grid in toolbox "Table" My Tables are with invisible lines right now... Do you know how? just to decorate... Thanks! MR