Search results for query: *

Thanks, the column is an auto increment so you have to make the assumption that the next ID is going to be (1 + max(ID column))?

I have a table with an identity column and would like to get the next value that it will use programmable before inserting into the table.

The error message; The query processor could not produce a query plan An example update statement is; update table1 set text_field = 'Hello World ' + dbo.fn_Return('12343234') where unique_id = 1 where dbo.fn_return returns a varchar data type. Regards

I have a new system with more processers and have copied a database from my existing system. On the existing system everything works fine, however on the new system any updates performed on fields with a datatype of text fail when the update text includes a call to a function that returns a...

I have two queries from seperate data sources; Source 1 Field1 Field2 1 Fred 2 Chris 3 Matt Source 2 Field1 Field2 1 1000 2 2550 3 5000 I have linked the two queries via Field 1. However, when I combine them in a table I get Field1 Name...

I have a textbox,held on a SSTab control, which when the form is displayed if is filled with large amount of text the textbox seems to disappear. When you click over the location of the textbox, the actual text is displayed but not the control outline.

I have an MSHFlexGrid with many rows, each cell on the top two rows have identical text across all columns. When I merge the two rows, the first is aligned to the left and second aligned to the right. Does any one know how to align both rows to the left.

I have created mobile application that detects the connection to an access point. The app works well, but returns the IP info for the device itself. What I need is the IP info for the access point?

I have a Winsock control that is to be used for SMTP email. When connecting I get the response from server through the DataArrival Event. However, once connected I start to sent the commands and get no response. If I try the same commands through telnet everything works OK.

Have you set the ScrollBars property of the flexgrid correctly. The value options are; 0 - None 1 - Horizontal 2 - Vertical 3 - Both

This might be a good starting point http://support.microsoft.com/kb/q143258/

Harlryquinn, You are on the right track, the system setup allows the user to dinamically determine which fields require data entry as manditory. Then as part of the update procedure I check to see which fields are manditory, check that the correct data hasa been entered, and if incorrect let...

Yes, You would start by creating the array; Dim recipes_added() To initialize the array with one item; ReDim Recipes_Added(0) To added to the array; ReDim Preserve Recipes_Added(UBound(Recipes_Added)+1)

Using a SSTab control with 4 tabs, each containing a number of additional controls. Is there a way that from the individual controls, I can determine which tab they are sitting on so that I can programmaticly select the correct tab?

Are you creating the contents of the listview from a recordset. If so try using a datalist, which has the same functionallity as a listview with a couple of extra features. To load the datalist from a recordset that contains two fields (PK_FieldName and Description); With DataList1 set...

For the example below, the starting listview is lvwDefaultProcess and dropping listview is lvwProcess; Firstly create two variables in the general declarations area of the form; Private itmProcess As ListItem Private blnProcessAdd As Boolean In the lvwDefaultProcess_OLEStartDrag event add...

I have added a menu to my application using the menu editor, is there any way that I can add graphics to each option? ED

Just to let everyone know, this is a bug with pasting dates into Execl programmable. This is only an issue when the regional short date format is set to dd/mm/yyyy. Execl does not take into consideration the short date format that has been set, but automatically uses the american format...

One way is to export the crystal report as a PDF or, if you want to allow them to edit it, RTF to a temporary location, then open a new message from your email client and attach the document.

I have the code below which pastes the contents of a listview into Excel. A number of the fields are dates which are shown in the system short date format (dd/mm/yyyy). The data is first copied to the clipbaord and then pasted. On viewing the spreadsheet, Excel converts those dates with a day...