Posts by Commando123

Hello,

I am facing a problem with the look and feel for oracle forms. I am using the file laf_11112.jar.
one Problem is that when we open a window the title bar displayes the text in squares. the language original text is in Arabic.

second problem is that we can not check the check box by pressing on its box but by pressing 1 cm further to the right.

Do u Know what settings should i shange to fix this, keeping in mind that my applicationn is in Arabic.
thank you

hi guys,
i have a datagridviewcheckboxcolumn1 that is bound to a field in a database. i want to set it as checked or uncheked programaticly, does any one know how??

but the checkbox is a coulmn in datagried view not an ordinary checkbox!!

hello guys,

can anyone help me with this plz??
i have a datagrid view that is bound to a database, and the is a checkbox that is also bound to a flg in this database.

i want to put some conditions on checking or unchecking this flg.

what event do u suggest to do this condition on? and how can i recheck or uncheck the check box in the datagridview after the conditions get uplied

i have tried this code but i still have a problem with checking the checkbox!!

Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles TransactionsDataGridView.CellContentClick
If Me.TransactionsDataGridView.Columns(e.ColumnIndex).Name = "DataGridViewCheckBoxColumn1" Then
  If TransactionsDataGridView.CurrentRow.Cells(7).Value = True Then
      MsgBox("Deleted transactions can not be undeleted")
  Else
     Dim result As DialogResult = MessageBox.Show("Are you shure you want to delete this transaction?", "Mobile Phone Solution", MessageBoxButtons.YesNo)
      If result = Windows.Forms.DialogResult.Yes Then
      End If
   End If
  End If
End Sub

thank you for the help.

hello guys,

can anyone help me with this plz??
i have a datagrid view that is bound to a database, and the is a checkbox that is also bound to a flg in this database.

i want to put some conditions on checking or unchecking this flg.

what event do u suggest to do this condition on? and how can i recheck or uncheck the check box in the datagridview after the conditions get uplied

i have tried this code but i still have a problem with checking the checkbox!!

Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles TransactionsDataGridView.CellContentClick
If Me.TransactionsDataGridView.Columns(e.ColumnIndex).Name = "DataGridViewCheckBoxColumn1" Then
  If TransactionsDataGridView.CurrentRow.Cells(7).Value = True Then
      MsgBox("Deleted transactions can not be undeleted")
  Else
     Dim result As DialogResult = MessageBox.Show("Are you shure you want to delete this transaction?", "Mobile Phone Solution", MessageBoxButtons.YesNo)
      If result = Windows.Forms.DialogResult.Yes Then

      End If
   End If
  End If
End Sub

thank you for the help.

hi guys,

i have a crystal report the display all transactions done, even the ones that are deleted, and there is a flg to know which ones are deleted.

i need to make a formula to calculate the sum of cash, the problem is that i dont know how to add a where condition not to add the deleted transactions to the totals.

i wrote this in the formula editor

Sum ({Transactions.Trans_Cash})

but this adds also the deleted ones. how can i ignore them. Transactions.Trans_delete_flg

thank you for the help

Hi Guys,

I am working with oracle Forms 11g and i want to navigate from one block to another,

i used to use GO_BLOCK('BLOCK_NAME') before(10g, 6i), but now its not working in 11g

i did a small resarch on the internet and its saying that GO_BLOCK must Work!!

Any Ideas??

hi guys i am puting this query in my querybuilder in the table adapter but i need to make the query only return
the transaction done today!! i dont know the syntax to get the cuurent date today. this query should work in the tableadapter query configuration wizard!!!

SELECT        Trans_ID, Trans_Cash, Trans_Deposit, Trans_Mtc, Trans_Alfa, Trans_Desc, Trans_Delete_Flg, Trans_Date, Trans_User_Name, Trans_Admin_Flg, 
                         Trans_Msg_Cost
FROM            Transactions
WHERE        (Trans_Admin_Flg = FALSE) AND (Trans_Date >= .....?????

thanks for the help

Hi Guys,
I am doing a report in crystal reports and i have 4 parameters.
when i run the report the parameters are displayed each on a separete page
i have to fill one by one and press next.

Is there a way to make all the parameters show on the same page, under each other??

i installed the sp1 and it worked thank man !!!

i tried to create a new project but the same problem occurred.
i can insert and update records, but if i insert a record and go
update the other before hitting the save button and then press the save button
the error appears. Concurrency violation 0 records updated expected 1

I did what you told me but an error came up
the error code was: -1
the source: microsoft.VSDesigner

any Idea??

i havent written any code, :), after i added the dataset i draged and droped the table from the data source to the form. so it created the datagried view with the bindingnavigator and the save button.
the save button contains

Me.Validate()
Me.TransactionsBindingSource.EndEdit()
Try
Me.TableAdapterManager.UpdateAll(Me.Mobile_Phone_SolutionDataSet)
Catch ex As Exception
MsgBox(ex.Message.ToString)
End Try
i added the try catch..
i am not an expert on vb.net because i am an oracle developer.
thank you for your help

Hey Guys

i am doing a small project and i am using vb.net with MS access database.

i am facing a Concurrency issue sometimes when i try to save data in the datagried view.

i have added the datagried view by draging and drop the table from the data source.

only one user is using the form to save data at one time.

i think it works properly unless i moved from record to recored then it gives me an error. "Concurrency, 0 records updated from expected 1....."

any one know how could i solv this issue??

Hey Guys

i am doing a small project and i am using vb.net with MS access database.

i am facing a Concurrency issue sometimes when i try to save data in the datagried view.

i have added the datagried view by draging and drop the table from the data source.

only one user is using the form to save data at one time.

i think it works properly unless i moved from record to recored then it gives me an error. "Concurrency, 0 records updated from expected 1....."

any one know how could i solv this issue??

how can i save the changes done on the datagridview to the database??

i want to be able to update my database tables from the dataview it self and without using textboxs

hi guys,
i know how to write a code to display data from the database into a datagridview, and i know how to use text boxs for uplying chnages on the database and directly display them in the datagridview, but what i want is to be able to aply changes without using textbox but directly the datagridview, so the user will be able to see that data on the datagriedview and insert his data in its field and update other and when he saves it will directly effect the database.
than you.

i added the data base from the vb it self, from the solution explorer, add new item. and i know the vb uses sql server.

hi guys,
i am using the vb 2005 to create an application and i created a database from the vb by adding a new Item(Database).
i want to know how can i make the id wich is a number,to take an auto number and not to have to enter it with my insert statment.
I know in oracle i use a sequence and in access i use Auto Number as a type for the field,i want somthing like this here
thank you.