Search results for query: *

hi, I'm trying to build a regex that catches everything between a FROM and WHERE of a sql clause (ie, the tables) EX: select * from t1, t2,t3, t4 x where ... i need the "t1, t2,t3, t4 x" i've tried several stuff and end up with this FROM\s+(?<tables>\w+\s*[,]?\s*)*(WHERE){0,1} but in...

Hi, I need a regular expression that matches this string: [{x:y:z}][{k:l:m}] ... with this pattern repeating n times i want to capture each word, that is: get the 'x', 'y', 'z', 'k'... i've tried something like this Dim re As New Regex("[{(\w):(\w):(\w)}]") Dim match As Match =...

hi chiph, I need it because i'm updating the dataset recursively.

Hi SavantMan, Thanks for your tip.. the thing is that i'm using constraints and relations in a strongly typed dataset, if i change the rowstate of a deleted row that eventualy has it's parent row with the row state marked as deleted as well, wouldn't i end up getting a constraint error...

Hi, I'm using strongly typed datasets. Somewhere in my application i need to access the child rows of a deleted datarow: deletedRow.GetChildRows in which i get an exception saying i can't access deleted row information. i know i can do something like deletedRow.Item("colName"...

Hi, Is it possible to create strongly typed datasets at runtime? The user in my application must login before any connection to the database is made. Also the connection to the database varies accordingly to the user, that is, i have diferent connect strings for diferent users.. thanks

with that and this modification... Private Sub label1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Label1.MouseMove If IsDragging Then Label1.Location = New Point(Me.ParentForm.MousePosition.X, Me.ParentForm.MousePosition.Y)...

hi, I want to move a control at runtime so i've starting by implement the following simple code: Private Sub label1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Label1.MouseDown IsDragging = True End Sub Private Sub...

well i've started the listener, but now i get an: ORA-1017: invalid username/password using the previous connect string.. do i have to create a user? I've created a Local Role with grant to connect, but i really don't know if this is what i have to do..

thanks for your reply, Now i get an ORA-12541: TNS:No listener found i went to the services manager and i really don't have a listener running, how do i start it?

Hi, I'm starting with Oracle 9i and it all seems very confusing to me.. I've installed the Database Server, after that i've used the Database Configuration Assistant to create a database, wich i've called TEST, with SID TEST. I've also installed the oracle data access client for .net It all...

it must be the user.. that's a problem right?

It's a primary key. Defined in the Data Base. Something like: Users Table ----------- USER_ID (pk) USER_NAME ETC

i forgot to mention the order suggestion in the book: 1) submit new parent records 2) submit new child records 3) submit modified parent records 4) submit modified child records 5) submit deleted child records 6) submit deleted parent records...

Hi, Having read Microsoft ADO .Net from David Sceppa, i come across an way to partially solve the order problem when updating a dataset that has hierarchical data. I've followed David Sceppa's suggestion in page 486: 1) submit new parent records 2) submit new child records 3) submit modified...

Hi, don't know if this is the right place for this question, but here it goes. Having read Microsoft ADO .Net from David Sceppa, i come across an way to partially solve the order problem when updating a dataset that has hierarchical data. I've followed David Sceppa's suggestion in page 486...

but i have oda1.Update(ds.pTable) oda2.Update(ds.cTable) ... the actual update in the database is done when i save and exit from the application, meanwhile i deleted parents with childs (ofcourse the childs and parent where deleted, but only in the DataSet). Are you saying this is impossible...

hi Christiaan, Are you saying i can't delete the parent and cascade through the childs? because that's what i want...

Hi, I'm having a hard time trying to update a table that has child tables. I have a DataSet with 8 tables and each DataSet was filled with a different OracleDataAdapter. Then i've created a relation between two of the tables like this: Dim col1 As DataColumn =...

Hi, This is a little hard to explain, so i will start with an example.. Suppose we have 20 records associated with a DataGrid, with the first row beeing the Active Row, and a Visible Region of 5 rows, in the beginning we can see rows 0 to 4 and if we scroll down we will see rows 1 to 5, and so...