Connect to a dbf

[Willy Hermans]

I am trying my first tests.
Connecting to a dbf does not go.
I add an oDbfDataSet1 and a oCdxDataSource1
I fill in the name of a database in the same map
I also add oDbBrowse1.
oDbBrowse1:oDataSet -> oDbfDataSet1
I add a collumn
The fieldnames of the dbf are not known.
I think it is a typical beginners error.
Does anybody know what I forgot.
Thanks.
Willy Hermans

[jfgimenez]

Willy,
>I am trying my first tests.
>
> Connecting to a dbf does not go.
>
> I add an oDbfDataSet1 and a oCdxDataSource1
> I fill in the name of a database in the same map
> I also add oDbBrowse1.
> oDbBrowse1:oDataSet -> oDbfDataSet1
> I add a collumn
>
> The fieldnames of the dbf are not known.
>
> I think it is a typical beginners error.
>
> Does anybody know what I forgot.
Please, use the option "Project" > "Publish project" and post here your
test. So we can see what is wrong.
--
Regards,
Jose F. Gimenez

[Willy Hermans]

Thanks Jose,
Here it is.
I added also the test.dbf and test.fpt file.
Greetings,
Willy Hermans
"Jose F. Gimenez" <jfgimenez@wanadoo.es> schreef in bericht
news:[email=426ca0e0@ozsrvnegro.ozlan.local...]426ca0e0@ozsrvnegro.ozlan.local...[/email]
> Willy,
>
>>I am trying my first tests.
>>
>> Connecting to a dbf does not go.
>>
>> I add an oDbfDataSet1 and a oCdxDataSource1
>> I fill in the name of a database in the same map
>> I also add oDbBrowse1.
>> oDbBrowse1:oDataSet -> oDbfDataSet1
>> I add a collumn
>>
>> The fieldnames of the dbf are not known.
>>
>> I think it is a typical beginners error.
>>
>> Does anybody know what I forgot.
>
> Please, use the option "Project" > "Publish project" and post here your
> test. So we can see what is wrong.
>
> --
> Regards,
>
> Jose F. Gimenez
>
>


Attached files test.zip (1.8 KB)Â

[jfgimenez]

Willy,
> Here it is.
>
> I added also the test.dbf and test.fpt file.
Thanks. I've just test it.
The problem is the existing column in the browse. If there is no column in
the browse, when you open the table the browse is filled with all the fields
of that table. But if there is any defined column in the browse, it doesn't
do anything, just to show the data defined in those columns.
So, simply delete that column and open the table directly, in design time.
You'll see how the browse is showed with 3 columns.
--
Regards,
Jose F. Gimenez

[Willy Hermans]

Hello,
Sorry but it stil does not work.
Here is exactely what I was doing.
In an empty form I've added
1) component oCdx - I made no changes in the properties
2) component oDbf. I filled in the name (and path) of the dbf. And I choose
the oCdx Datasource
3) Datacontrol tDbBrowse. I filled in the property oDataset. There was only
one choice - oDbfDataSet1 -
The appearance of the browse change. There was now a vertical scrollbar. But
there were no collumns.
I think the collumns should appear filling in the propery
oBrowse:oDataSet
>> So, simply delete that column and open the table directly, in design
>> time.
You'll see how the browse is showed with 3 columns
What do you mean with open the table directly in design time. I've clicked
on the TDBBRowse icon and then I clicked on an empty place in the form
Any idea.
Thanks,
Willy Hermans.

[jfgimenez]

Willy,
>>> So, simply delete that column and open the table directly, in design
>>> time.
> You'll see how the browse is showed with 3 columns
>
> What do you mean with open the table directly in design time. I've clicked
> on the TDBBRowse icon and then I clicked on an empty place in the form
Change the property lOpen in the DataSet to .T.. Just in that moment you'll
see how the browse shows the three columns.
--
Regards,
Jose F. Gimenez

[Willy Hermans]

Hello,
I've just tested it.
Everything seems to work fine now.
Many thanks
Willy Hermans.
"Jose F. Gimenez" <jfgimenez@wanadoo.es> schreef in bericht
news:426cc810$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Willy,
>
>>>> So, simply delete that column and open the table directly, in design
>>>> time.
>> You'll see how the browse is showed with 3 columns
>>
>> What do you mean with open the table directly in design time. I've
>> clicked on the TDBBRowse icon and then I clicked on an empty place in the
>> form
>
> Change the property lOpen in the DataSet to .T.. Just in that moment
> you'll see how the browse shows the three columns.
>
> --
> Regards,
>
> Jose F. Gimenez
>