PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV (earlier versions) → HF Client Server
HF Client Server
Started by noupieple Hugues, Jul., 09 2009 1:44 PM - 7 replies
#1
Posted on July, 09 2009 - 1:44 PM
Hello,

How do i CREATE table in an Client Server database. Tables created in my Analysis does not appear automatically there. how do i manage the analysis and the HF Client server Control centre.


Hugues
#2
Posted on July, 09 2009 - 2:34 PM
noupieple Hugues a écrit :
Hello,

How do i CREATE table in an Client Server database. Tables created in my Analysis does not appear automatically there. how do i manage the analysis and the HF Client server Control centre.


Hugues


You do have create the tables using the software you are programming.
Search for HChangeConnection HCreationIfNotFound
First you have to change the connexion of your files to locate them on
your HF Server.
Then create the tables.
#3
Posted on July, 10 2009 - 11:19 AM
HELLO,

THANKS FOR YOUR REPLY.

THATS EXACTLY WHAT I VE DONE, THE CONNECTION IS POINTING TO THE HF SERVER. SOME FILES ARE CREATED ON THE HF C/S DATABASE BUT SOME NOT. SO I DONT KNOW WHY.
WHEN EDITING THE PROPERTIES OF THE FILE I SEE THE CONNECTION TO THE SERVER IS WELL DEFINE.

THANKS

HUGUES
#4
Posted on September, 16 2010 - 9:15 AM
Huges,

As was told to you, you can use the functions that check if the database exists, if their don't exist, create them.

I'm a novice in Windev, and in my last programming language (VB6) I used this kind of code to deploy the app.

In windev, I cannot tell you if the tables are automatic created, but, when the automation doesn't work, put code on that!

Good luck.
#5
Posted on September, 16 2010 - 3:48 PM
Le 10/07/2009 10:19, noupieple Hugues a écrit :
HELLO,

THANKS FOR YOUR REPLY.

THATS EXACTLY WHAT I VE DONE, THE CONNECTION IS POINTING TO THE HF SERVER. SOME FILES ARE CREATED ON THE HF C/S DATABASE BUT SOME NOT. SO I DONT KNOW WHY.
WHEN EDITING THE PROPERTIES OF THE FILE I SEE THE CONNECTION TO THE SERVER IS WELL DEFINE.

THANKS

HUGUES

If you could paste your code it could help to find what's going wrong.

I use that kind of code (translate from french code)
------------------------------------------------------------------------
gsConnexion is Connection


gsCS_USER is string = "User"
gsCS_PASSWORD is string = "Password"
gsCS_SERVEUR is string = "Server"
gsCS_PORT is string = "4900"
gsCS_BDD is string = "MyDB"

tFichiers is array of 0 strings

ArrayAdd(tFichiers,"FirstFile")
ArrayAdd(tFichiers,"SecondFile")
ArrayAdd(tFichiers,"ThirdFile")

gsConnexion..Provider = hAccessHFClientServer
gsConnexion..User = gsCS_USER
gsConnexion..Password = gsCS_PASSWORD
gsConnexion..Server = gsCS_SERVEUR+":"+gsCS_PORT
gsConnexion..Database = gsCS_BDD
gsConnexion..CryptMethod = hCryptNo


// Ouverture de la connexion
IF NOT HOpenConnection(gsConnexion) THEN
Info(HErrorInfo(hErrFullDetails))
RESULT False
END

FOR i = 1 _TO_ tFichiers..Occurrence
IF NOT HChangeConnection(tFichiers[i],gsConnexion) THEN
Info(HErrorInfo(hErrFullDetails))
RESULT False
END

IF NOT HCreationIfNotFound(tFichiers[i]) THEN
Info(HErrorInfo(hErrFullDetails))
RESULT False
END
END

RESULT True
------------------------------------------------------------------------------------
#6
Posted on September, 16 2010 - 3:52 PM
Hi Hugues

1. Please stop 'SHOUTING'

2. In the analysis, in the details of each file, you can check the
option to have the file automatically created if it's not there. From
your description, it seems that some are and some are not checked

Best regards


--
Fabrice Harari
Consultant WinDev, WebDev et WinDev Mobile International

Plus d'information sur http://fabriceharari.com/index_FR.html


On 10/07/2009 04:19, noupieple Hugues wrote:
HELLO,

THANKS FOR YOUR REPLY.

THATS EXACTLY WHAT I VE DONE, THE CONNECTION IS POINTING TO THE HF SERVER. SOME FILES ARE CREATED ON THE HF C/S DATABASE BUT SOME NOT. SO I DONT KNOW WHY.
WHEN EDITING THE PROPERTIES OF THE FILE I SEE THE CONNECTION TO THE SERVER IS WELL DEFINE.

THANKS

HUGUES
#7
Posted on September, 16 2010 - 4:43 PM
Hi

I would be more than suspicious with that option for an HF/CS
configuration.
It could be very usefull when you are using HF classic with
predetermined folders for the files.
With HF/CS the server name would change each time you will setup a new
customer.

Bye
Goof

Le 16/09/2010 14:52, Fabrice Harari a écrit :
Hi Hugues

1. Please stop 'SHOUTING'

2. In the analysis, in the details of each file, you can check the
option to have the file automatically created if it's not there. From
your description, it seems that some are and some are not checked

Best regards
#8
Posted on September, 16 2010 - 5:35 PM
Hi Goof

yes the server will change, and once it's setup, the file will be
created without any problem

Best regatrds


--
Fabrice Harari
Consultant WinDev, WebDev et WinDev Mobile International

Plus d'information sur http://fabriceharari.com/index_FR.html


On 16/09/2010 09:43, Goof wrote:
Hi

I would be more than suspicious with that option for an HF/CS
configuration.
It could be very usefull when you are using HF classic with
predetermined folders for the files.
With HF/CS the server name would change each time you will setup a new
customer.

Bye
Goof

Le 16/09/2010 14:52, Fabrice Harari a écrit :
Hi Hugues

1. Please stop 'SHOUTING'

2. In the analysis, in the details of each file, you can check the
option to have the file automatically created if it's not there. From
your description, it seems that some are and some are not checked

Best regards
→ Go back to WINDEV (earlier versions)